PivotCache object (Excel)
Represents the memory cache for a PivotTable report.
The PivotCache object is a member of the PivotCaches collection.
Use the PivotCache method of the PivotTable object 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 (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.
ActiveWorkbook.PivotCaches(1).Refresh
- ADOConnection
- Application
- BackgroundQuery
- CommandText
- CommandType
- Connection
- Creator
- EnableRefresh
- Index
- IsConnected
- LocalConnection
- MaintainConnection
- MemoryUsed
- MissingItemsLimit
- OLAP
- OptimizeCache
- Parent
- QueryType
- RecordCount
- Recordset
- RefreshDate
- RefreshName
- RefreshOnFileOpen
- RefreshPeriod
- RobustConnect
- SavePassword
- SourceConnectionFile
- SourceData
- SourceDataFile
- SourceType
- UpgradeOnRefresh
- UseLocalConnection
- Version
- WorkbookConnection
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.