PivotTable.CacheIndex (Excel)

Returns or sets the index number of the PivotTable cache.

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.

ActiveCell.PivotTable.CacheIndex =