PivotCaches Collection Object
Description
Represents the collection of PivotTable memory caches in a workbook. Each memory cache is represented by a PivotCache object.
Using the PivotCaches Collection
Use the PivotCaches method to return the PivotCaches collection. The following example sets the RefreshOnFileOpen property for all pivot caches in the active workbook.
For Each pc In ActiveWorkbook.PivotCaches
pc.RefreshOnFileOpen = True
Next
Properties
Application property, Count property, Creator property, Parent property.
Methods
Item method (PivotCaches collection).