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.