PivotCache Object [Excel 2003 VBA Language Reference]


Represents the memory cache for a PivotTable report. The PivotCache object is a member of the PivotCaches collection.

Using the PivotCache Object

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.


Properties | ADOConnection Property | Application Property | BackgroundQuery Property | CommandText Property | CommandType Property | Connection Property | Creator Property | EnableRefresh Property | Index Property | IsConnected Property | LocalConnection Property | MaintainConnection Property | MemoryUsed Property | MissingItemsLimit Property | OLAP Property | OptimizeCache Property | Parent Property | QueryType Property | RecordCount Property | Recordset Property | RefreshDate Property | RefreshName Property | RefreshOnFileOpen Property | RefreshPeriod Property | RobustConnect Property | SavePassword Property | SourceConnectionFile Property | SourceData Property | SourceDataFile Property | SourceType Property | UseLocalConnection Property

Methods | CreatePivotTable Method | MakeConnection Method | Refresh Method | ResetTimer Method | SaveAsODC Method

Parent Objects

Child Objects

See Also | PivotCell Object | PivotFields Collection Object | PivotFormula Object | PivotItem Object | PivotItemList Collection | PivotLayout Object | PivotTable Object