PivotCache Object

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.

Worksheets(1).PivotTables(1).PivotCache.RefreshOnFileOpen = True

Use PivotCaches(), where is the PivotTable cache number, to return a single PivotCacheobject from the PivotCachescollection for a workbook. The following example refreshes cache one.

ActiveWorkbook.PivotCaches(1).Refresh

See also:

• Excel Object Model Reference
• PivotCache Object Members
• PivotCell Object
• PivotFields Object
• PivotFormula Object
• PivotItem Object
• PivotItemList Object
• PivotLayout Object
• PivotTable Object