HomePrivacy PolicyFeedbackLink to usSite Map

MS 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 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

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.