...
Wiki Markup |
---|
{introducedin: 8.4 |
...
Description |
---|
Excerpt |
---|
Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document. |
Signature | |||
---|---|---|---|
C# | C# | }
{description}
{excerpt}Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document.{excerpt}
{signature:C#}
public boolean RefreshOnOpen{ get; set; }
| |
Signature | |||
{signature}{signature:vb.net | vb.net | }
Public Property RefreshOnOpen() As Boolean
| |
Example | |||
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vbnet | vbnet | title |
Remarks | |||
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. SettingRefreshOnOpen is the same as going to PivotTable Options > Data and checking or unchecking Refresh data when opening the file. {code}
{example}
{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_.
{remarks} |