Pivot Table External Data Location Change

[Turbo613]

Ok, experts, how do I update the data source for a Pivot Table to an access MDB for office 2003? I know I right click on the pivot, select wizard, then click the back button to the data source (step 2 of 3 in the wizard), click the get data button..., and then what? I don't see an option to point to a new location for a data source??? Any ideas?

Thx Turbo/Mike

 

[NateO]

Hi Mike,

See the following:

http://support.microsoft.com/kb/816562

 

[Turbo613]

thanks for the info. is there a way to change the link in the wizard instead of doing the code as in the previous link from this post?

 

[NateO]

You're welcome.

Well, according to Microsoft (from the link I provided):

SUMMARY
After you change the folder location or the server name of a database that a query or PivotTable is using in Microsoft Excel, you cannot manually change the connection information to the new folder or to the server. This article offers a programmatic solution.

So, as I read that, not so much... And I know of no other way... But this is pretty simple stuff to implement, once you follow it.

 

[Turbo613]

Thanks for the helpful info. It worked...