Hi - just a general, perhaps naive question for anyone who knows about PivotCaches and their relationship with PivotTables ...

I understand PivotCaches are just that - caches of data used by PivotTables.

What I don't know is whether the logical relationship between worksheet data and a pivot object is through the pivot table, or through the pivot cache.

... for example, when I try to update the SourceData property of a pivot cache object (i.e. by referencing the pivot cache directly, as a child of the active workbook), the process fails. I can READ the source data property, but can't set it.

Please Login or Register  to view this content.
...trying to change things:
Please Login or Register  to view this content.
... but then,

Please Login or Register  to view this content.

It seems like I HAVE TO updated the sourcedata via the pivot table, and can't do this via the pivot cache.

Why ?????

If I have multiple pivot tables feeding off the same cache, can i change one pivot table's sourcedata property, thereby automatically changing the pivotcache sourcedata property, and expect for all other pivot tables that use the same pivot cache to have their sourcedata updated automatically ? If yes, do all the other pivot tables need to be manually refreshed before the change in source will be visible in the other tables ?


Just a little confused here; probably missing something foundational that MS doesn't do a good job explaining in their literature.


Thanks for any assistance.