PivotTable.PivotCache Method

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

• PivotTable Object
• PivotTable Members