PivotCache object (Excel)

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.

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

Methods

Name
CreatePivotChart
CreatePivotTable
MakeConnection
Refresh
ResetTimer
SaveAsODC

Properties

Name
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

See also

Excel Object Model Reference