Excel: Change data source for a pivot table in Excel 2003/XP/2000/97

Also learn how to change the data source for a pivot table in Excel 2007.

Question:  In Excel 2003/XP/2000/97, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?

Answer: Select any cell in the pivot table. Right-click and select "Wizard" from the popup menu.

When the PivotTable and PivotChart Wizard window appears, click on the Back button.

Select the new data source for the pivot table and click on the Finish button.