PivotCache.RefreshOnFileOpen Property
True if the PivotTable cache is automatically updated each time the workbook is opened. The default value is False.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property RefreshOnFileOpen As Boolean
Get
Set
'Usage
Dim instance As PivotCache
Dim value As Boolean
value = instance.RefreshOnFileOpen
instance.RefreshOnFileOpen = value
bool RefreshOnFileOpen { get; set; }
Property Value
Type: System.Boolean
Remarks
PivotTable reports are not automatically refreshed. Use the Refresh method to refresh the data after the workbook is open.