PivotCaches Object

Excel Developer Reference

Represents the collection of memory caches from the PivotTable reports in a workbook.


Each memory cache is represented by a PivotCache object.


Use the PivotCaches method to return the PivotCaches collection. The following example sets the RefreshOnFileOpen property for all memory caches in the active workbook.

Visual Basic for Applications
  For Each pc In ActiveWorkbook.PivotCaches
    pc.RefreshOnFileOpen = True

See Also