...
Introducedin | ||
---|---|---|
|
...
|
Description |
---|
Excerpt |
---|
Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document. |
Signature | ||||
---|---|---|---|---|
| ||||
public boolean RefreshOnOpen{ get; set; }
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Property RefreshOnOpen() As Boolean
{signature}
{example}{code:csharp|title=C#} |
Example | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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. Setting |