Found the Solution -

From within the Access database, and your are linking the SQL Server table to the Access db, be sure to check "Save Password". Then the Excel SQL pulling data thru the Access DB linked to table in SQL server will work.