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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Current »

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