How to refresh pivot chart while automating the proccess?
If the output file is based on a Pivot Table / Pivot Chart template, ensure the pivot is refreshed after the data is updated.
Manual Configuration in Template
-
Open the Pivot template file.
-
Right-click on the Pivot Table.
-
Select PivotTable Options.
-
Go to the Data tab.
-
Enable “Refresh data when opening the file.”
-
Click OK and save the template.
With this setting enabled, when the bot generates the output file, the Pivot Table and corresponding Pivot Chart will automatically refresh whenever the end user opens the file.
