1. Select a cell in the PivotTable report.
2. Right click the cell and select Table Options -> Data tab -> check Refresh data when opening the file - > click OK.