Pivot Cache Object and the Pivot Caches Collection

The PivotCaches collection holds the collection of memory caches holding the data associated with a PivotTable report. Each PivotCache object represents a single memory cache for a PivotTable report. The parent of the PivotCaches collection is the Workbook object. Also, a possible parent of the PivotCache object is the PivotTable object.

The PivotCaches collection has a Create method besides the typical collection attributes. The Create method takes a SourceType constant (from the XlPivotTableSourceType constants) and SourceData to add a PivotCache to the collection.

Was this article helpful?

0 0

Post a comment