Edit

Share via


PivotCache.RefreshOnFileOpen Property

Definition

True if the PivotTable cache is automatically updated each time the workbook is opened. The default value is False.

public:
 property bool RefreshOnFileOpen { bool get(); void set(bool value); };
public bool RefreshOnFileOpen { get; set; }
Public Property RefreshOnFileOpen As Boolean

Property Value

Remarks

PivotTable reports are not automatically refreshed. Use the Refresh() method to refresh the data after the workbook is open.

Applies to