Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document.

C#
vb.net

Examples

C#
vb.net

Remarks

RefreshOnOpen is false by default.

When creating or modifying a PivotTable with ExcelWriter, make sure to set this property to see the changes. If this property is not set in code or in a template, the PivotTable will not reflect changes made with ExcelWriter code.

Setting RefreshOnOpen is the same as going to PivotTable Options > Data and checking or unchecking Refresh data when opening the file.

  • No labels