I have the same question! Our server (small office) went down and we had to
move the MS Access database file to another location. My excel worksheet
will not refresh and I can not find a way to trace this file!

Thanks

"Will C." wrote:

I have multiple spreadsheets referring to a single 'data source' spreadsheet
(different file). How can I move that all important single spreadsheet to a
different directory and still have the pivot tables in the dependant
spreadsheets find the data source?