Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

How to Automatically Refresh Pivot Tables When Excel is Opened


Overview

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.

Process

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?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments