Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing 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 -- Wyvern ------------------------------------------------------------------------ Wyvern's Profile: http://www.excelforum.com/member.php...fo&userid=5743 View this thread: http://www.excelforum.com/showthread...hreadid=521991 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Range on Pivot Cache
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 -- Wyvern ------------------------------------------------------------------------ Wyvern's Profile: http://www.excelforum.com/member.php...fo&userid=5743 View this thread: http://www.excelforum.com/showthread...hreadid=521991 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Clear a Pivot Table Cache | Excel Discussion (Misc queries) | |||
Pivot Cache - Massive Spreadsheet | Excel Discussion (Misc queries) | |||
Pivot cache | Excel Discussion (Misc queries) | |||
error message with Pivot Cache | Excel Programming | |||
Pivot Cache Memory | Excel Programming |