 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2006Changing Range on Pivot Cache
Hi, I would like some help please. I have a swag of pivot tables (that I've structured to all point to the same pivot cache). As part of a regular process I need to assign this cache to point to new Data files and new Data ranges. I've found a pice of code that seems to do it when you are creating a new pivot cache (using SourceData:= Range("A1").CurrentRegion.Address) but I'm not sure how to modify an existing pivot range. Can anyone please help? Many thanks, Geoff  SignatureWyvern Hi All, Just in case anyone experiences this problem too. I did find out how to do it. But my final solution was to create my own pivot cache and then spawn all the required pivot tables (2000+) from the created caches. Whilst it did take me quite a while to figure out how to do this, it proves a far more robust solution than creating pivot tables manually and modifying the cache. They tend to behave in strange ways sometimes. Geoff SignatureWyvern |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.