How to change data source in Pivot Table?

Last Post 01 Jun 2005 05:53 PM by clarkdev. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

26 May 2005 08:31 AM
We are migrating to new servers and I need to change my pivot table (EXCEL 2002) report to reference the new servers. How can I do this?

New Member
New Member

01 Jun 2005 05:53 PM
I did this (a couple of years ago) using VBA code to modify the PivotTable's PivotCache connection information. I can't remember all the syntax, but it worked. It's probably something you could do once, and then re-save the Excel files without the VBA code.


Steven D. Clark

Acceptable Use Policy