MS Excel 2003: How to Change Data Source for a Pivot Table
This Excel tutorial explains how to change the data source for a pivot table 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, 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.
Advertisements