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