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.
|
Suggested Reading
Home | About Us | Our Services | Software | Excel Templates | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
