PivotCaches Object (Excel)
Represents the collection of memory caches from the PivotTable reports in a workbook.
Remarks
Each memory cache is represented by a PivotCache object.
Example
Use the PivotCaches method to return the PivotCaches collection. The following example sets the RefreshOnFileOpen property for all memory caches in the active workbook.
For Each pc In ActiveWorkbook.PivotCaches
pc.RefreshOnFileOpen = True
Next