How do I update Excel pivot table for database that was moved?

S

Steve

I have a pivot table in Excel that automatically refreshed when the
spreadsheet is opened to a query in Access. I recently moved the Access
database to a new folder and do not want to move it back as it is in the
innappropriate location. When the pivot table tries to update, it tells me
the path is not correct and brings up a dialog box with an admin login name.
Not sure where to go from here to relink. Any suggestions?
 
Top