MS Excel: Automatically refresh pivot table when file is opened in Excel 2011 for Mac
Also learn how to automatically refresh pivot table when file is opened in Excel 2011 | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.
Question: In Excel 2011 for Mac, how do I get a pivot table to automatically refresh when the Excel spreadsheet is opened?
Answer: Right-click on the pivot table and then select "PivotTable Options" from the popup menu.
When the PivotTable Options window appears, select the Data tab and check the checkbox called "Refresh data when opening file". Click on the OK button.
