Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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



Community Additions

Show: