Excel: Automatically refresh pivot table when file is opened in Excel 2003/XP/2000/97

Also learn how to automatically refresh pivot table when file is opened in Excel 2007.

Question:  In 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.