PivotTable.PivotCache Method

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.

Visual Basic for Applications
`Worksheets(1).PivotTables("Pivot1") _ .PivotCache.OptimizeCache = True`

pivot pivot cache Pivot Cache Method PivotCache pivotcache method reference pivot table's cache represent pivot table cache object return pivot table's cache

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

See also: