- Right-click any cell in your pivot table.
- Click PivotTable Options.
- In the PivotTable Options window, click the Data tab.
- In the PivotTable Data section, add a check mark to Refresh Data When Opening the File.
- Click OK to close the dialog box.
Modified on: Fri, Jan 27, 2017 at 4:48 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.