PivotCache Object [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
PivotCache Object
Represents the memory cache for a PivotTable report.

Remarks

The PivotCache object is a member of the PivotCaches collection.

Example

Use the PivotCache method to return a PivotCache object for a PivotTable report (each report has only one cache). The following example causes the first PivotTable report on the first worksheet to refresh itself whenever its file is opened.

Visual Basic for Applications
Worksheets(1).PivotTables(1).PivotCache.RefreshOnFileOpen = True

Use PivotCaches(

index), where index is the PivotTable cache number, to return a single PivotCache object from the PivotCaches collection for a workbook. The following example refreshes cache one.
Visual Basic for Applications
ActiveWorkbook.PivotCaches(1).Refresh

See Also