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?