MS Excel 2003: Automatically refresh pivot table when file is opened
This Excel tutorial explains how to automatically refresh a pivot table when the spreadsheet file is opened in Excel 2003 and older versions (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2003/XP/2000/97, how do I get a pivot table to automatically refresh when the Excel spreadsheet is opened?
Answer: Select a cell in the pivot table. Right-click and then select "Table Options" from the popup menu.
When the PivotTable Options window appears, check the checkbox called "Refresh on open". Click on the OK button.
Advertisements