MS Query/Pivot Table Reference Change

Situation: I am using an Access db as the source of information for a pivot table. Currently the db is on an external drive, but I would like to move it to a local drive so I made a copy of the db. Going through the Pivot Table Wizard, I wanted to change where my pivot table looks to access the db. Once in MS Query, I go through the SQL dialog button and change the file path. Once I go back into Excel/Pivot Table, it seems to refresh the data. When I actually remove the db from the external drive and refresh the pivot tables, I get the error message: 'Could not find file: '[External Drive]:\[filename].mdb.'' I noticed that when I do refresh the table with the db on the external drive and a copy on the local drive, it accesses both files.

Question: If I change the file path in the SQL dialog, is there another place I need to make the change?

Any help would be appreciated.

Thanks,

Ryan