PivotCache.OptimizeCache Property (Excel)

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

Syntax

expression. OptimizeCache

expression A variable that represents a PivotCache object.

Remarks

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

For OLE DB data sources, this property is read-only and always returns False .

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

PivotCache Object