PivotCache.OptimizeCache Property
True if the PivotTable cache is optimized when it’s constructed. The default value is False.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property OptimizeCache As Boolean
Get
Set
'Usage
Dim instance As PivotCache
Dim value As Boolean
value = instance.OptimizeCache
instance.OptimizeCache = value
bool OptimizeCache { get; set; }
Property Value
Type: System.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.