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 of the Workbook object 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

Methods

• Create
• Item

Properties

• Application
• Count
• Creator
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.