How to change data source in Pivot Table?

Last Post 01 Jun 2005 04:53 PM by clarkdev. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DBADave
New Member
New Member

--
26 May 2005 07: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?

Dave
clarkdev
New Member
New Member

--
01 Jun 2005 04: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.

-Steve

Steven D. Clark
stevec@clarkdev.com
You are not authorized to post a reply.

Acceptable Use Policy