Where is the information stored along with Pivot Tables for connecting to external data source.
I have lots of Workbooks having pivot tables. Each Pivot table is made from External database- SQL SERVER.
For some reason I had to move my Database from one server to another server. I edited the dsn entry in ODBC configuration pointing to new server, but still excel is trying to look for old database in old server. (Original location).
How can I make excel look for New Server for these Pivot Tables.
I have kept even the DSN name same as original.
Please help since there are approximately 200 queries made and changing all these again would mean lots and lots of pain and time
I have lots of Workbooks having pivot tables. Each Pivot table is made from External database- SQL SERVER.
For some reason I had to move my Database from one server to another server. I edited the dsn entry in ODBC configuration pointing to new server, but still excel is trying to look for old database in old server. (Original location).
How can I make excel look for New Server for these Pivot Tables.
I have kept even the DSN name same as original.
Please help since there are approximately 200 queries made and changing all these again would mean lots and lots of pain and time