PivotCache Method

Applies To

PivotTable object.

Description

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

Syntax

expression.PivotCache

expression Required. An expression that returns a PivotTable object.

Example

This example causes the PivotTable cache to be optimized when it's constructed.

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