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
 

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 with Data Model Connection - getpivotdata reference issue 0
Excel does not accept text format! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
sqlite-odbc write conflict 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Table Security in Access 2013 1
DATE Calculations in pivot table 0

Top