How to change pivot table source database?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

How can I change the source database for a pivot table in
an Excel spreadsheet. Our database server has been
changed and when I create a new dsn pointing to the
correct server, I get an error message indicating that the
query on the old server is still trying to be used.
Thanks,
Steve
 
This should work for you (?)
Open the pivot table and click on it.
Menu - Data/Pivot Table report.
Click the Back button on the Wizard dialog that appears and connect t
the new data source
 

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

OLAP Pivot Table 1
Pivot table change data source 1
Excel / Sql Server / Pivot Tables 2
How can I change the source data reference to another pivot table? 2
Easy way to change Pivot table source files? 5
Q: Change pivot table source path? 1
Excel 2007 pivot table source table 1
Changing ODBC datasource for a Pivot Table 2

Back
Top