OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 5

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 6

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

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

...

Remarks

RefreshOnOpen is false by default.

When creating or modifying a pivot table 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 pivot table PivotTable will not reflect changes made with ExcelWriter code.