How to change pivot table source database?

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
 
B

BrianB

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
 
Top