PivotCaches Collection Object [Excel 2003 VBA Language Reference]
PivotCaches PivotCache |
Represents the collection of memory caches from the PivotTable reports 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 memory 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 | Add Method | Item Method
Parent Objects
Child Objects
See Also | PivotCell Object | PivotField Object | PivotFormula Object | PivotItem Object | PivotItemList Collection | PivotTable Object