PivotCaches Object
TOC
Collapse the table of content
Expand the table of content

PivotCaches Object (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

For Each pc In ActiveWorkbook.PivotCaches 
 pc.RefreshOnFileOpen = True 
Next
Show:
© 2016 Microsoft