This documentation is archived and is not being maintained.

PivotCache Object

Office 2007
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



Show: