OptimizeCache Property

Applies To

PivotCache object.

Description

True if the PivotTable cache is optimized when it's constructed. The default value is False. Read/write Boolean.

Remarks

Cache optimization results in additional queries and degrades initial performance of the PivotTable.

Example

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

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