This topic has not yet been rated - Rate this topic

OptimizeCache Property [Excel 2003 VBA Language Reference]

Office 2003

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 report.

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

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

Applies to | PivotCache Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)