Share via


PivotTable.PivotCache Method (Excel)

Returns a PivotCache object that represents the cache for the specified PivotTable report. Read-only.

Syntax

expression .PivotCache

expression A variable that represents a PivotTable object.

Return Value

PivotCache

Example

This example causes the PivotTable cache for the first PivotTable report on worksheet one to be optimized when it’s constructed.

Worksheets(1).PivotTables("Pivot1") _ 
 .PivotCache.OptimizeCache = True 

See Also

Concepts

PivotTable Object Members

PivotTable Object