.
...
| Note |
|---|
Take special note of the data options, particularly Refresh data when opening the file and Number of items to retain per field. |
Since ExcelWriter cannot render PivotTables on the server, if a PivotTable or PivotTable data source is modified with ExcelWriter, those changes will not be reflected until the PivotTable is refreshed. Therefore, we always encourage you to turn on Refresh data when opening the file or PivotTableSettings.RefreshOnOpen.
...
, as they are important for ensuring properly rendered PivotTables in ExcelWriter output. More details are available in our ExcelTemplate Templates and PivotTables and ExcelApplication Creating a Basic PivotTable tutorials. |
PivotTable Field
PivotTable Field Settings
...