source database for Excel pivot tables

S

Steve Huber

How can I change the source database for a pivot table in
and Excel spreadsheet. Out 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
 
Top