moving pivot table data source files

G

Guest

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?
 
G

Guest

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
 
G

Guest

Depending on how you have your data sourced - under the 'Data\Import External
Data menu in Excel you should be able to use the 'Refresh' command and also
edit both external queries and/or linked data ranges so that they point to
the new source location. Depending on how many data sources and links you
have set up this could be a little tedious but still better than rebuilding
the entire worksheet if it is complex.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Data Dource Question 1
Getting source data range in multiple pivot tables 1
Date/Time issue with Pivot Table 3
Automatically Refresh pivot table 6
Move and Copy Pivot Table and Source Data 4
How can I change the source data reference to another pivot table? 2
Easy way to change Pivot table source files? 5
pivot table data 2

Top