PivotCaches Object

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

See also:

• Excel Object Model Reference
• PivotCaches Object Members
• PivotCell Object
• PivotField Object
• PivotFormula Object
• PivotItem Object
• PivotItemList Object
• PivotTable Object