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