Expand Minimize

PivotTable.CacheIndex Property (Excel)

Returns or sets the index number of the PivotTable cache. Read/write Long.

expression .CacheIndex

expression A variable that represents a PivotTable object.

If you set the CacheIndex property so that one PivotTable report uses the cache for a second PivotTable report, the first report’s fields must be a valid subset of the fields in the second report.

This example sets the cache for the PivotTable report named "Pivot1" to the cache of the PivotTable report named "Pivot2."

Worksheets(1).PivotTables("Pivot1").CacheIndex = _ 
 Worksheets(1).PivotTables("Pivot2").CacheIndex
Show:
© 2014 Microsoft