Excel.PivotCache.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotCache object (Excel)	vbaxl10.chm226072	vbaxl10.chm226072	Excel.PivotCache	c3d84ef1-f9e6-b1bc-cbf0-3ba8dfe17439	03/30/2019	medium

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 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

Methods

• CreatePivotChart
• CreatePivotTable
• MakeConnection
• Refresh
• ResetTimer
• SaveAsODC

Properties

• 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

[!includeSupport and feedback]