PivotCache.EnableRefresh property

True if the PivotTable cache or query table can be refreshed by the user. The default value is True.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

bool EnableRefresh { get; set; }

Property value

Type: System.Boolean

The RefreshOnFileOpen property is ignored if the EnableRefresh property is set to False.

For OLAP data sources, setting this property to False disables updates.