Sets or returns whether Microsoft Excel will automatically refresh a pivot table and the pivot table cache when Excel opens the document. |
public boolean RefreshOnOpen{ get; set; } |
Public Property RefreshOnOpen() As Boolean |
|
RefreshOnOpen is When creating or modifying a pivot table 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 pivot table will not reflect changes made with ExcelWriter code. |