Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

How to Automatically Refresh Pivot Tables When Excel is Opened


Some users will want reports that contain pivot tables to be automatically refreshed and updated when the report itself is opened. This functionality exists natively in Excel and can be turn on by following the instructions below.


First, the user should open the Excel file to be refreshed automatically. One the Excel file is opened the user should right click anywhere in the pivot table to be updated and select "PivotTable Options..." at the bottom of the selection list:

On the Data tab of the PivotTable Options window the "Refresh data when opening the file" box should be checked:

The user can then click "Ok" to save the changes.

These steps should be followed for each pivot table in the Excel workbook that should be refreshed automatically when the workbook is opened.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request