How to Change Pivot Table Source Data

In the Microsoft Excel spreadsheet application you can manage data and perform various calculations. You can also create a pivot table, which is a report that analyzes and summarizes your data. You can easily create a pivot table report using the PivotTable and PivotChart Wizard. After your pivot table has been created, you can still make changes and additions to your data. You can also select a new range of cells from the spreadsheet to be used for your pivot table.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Microsoft Excel 2007

Step

Open the Microsoft Excel 2007 application on your computer. Click on the “Microsoft Office” button from the top-right corner of the application.

Step

Click on the “Open” option and then locate the Excel 2007 file that contains the pivot table for which you want to change the data source. Click on the “Open” button.

Step

Click on the “Options” tab from the top toolbar menu and then click on the “Change Data Source” button from the “Data” group.

Step

Click on the radio button next to the “Select a table or range” field. Click on the button in the “Table/Range” field.

Step

Select the new range for your data within the pivot table and then click the “OK” button in the Change Pivot Table Data Source dialog box.

Microsoft Excel 2003

Step

Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu.

Step

Click on the “Open” option and then find the Excel 2003 file that contain the pivot table for which you want to change the data source. Select the file and then click on the “Open” button.

Step

Right-click on any cell in the pivot table and then click on the “Wizard” option. The PivotTable and PivotChart Wizard will appear on the screen.

Step

Click on the “Back” button. Select the radio button next to the “Existing worksheet” field and then click inside of the text box.

Step

Select the new range for your pivot table within the spreadsheet and then click on the “Finish” button from the dialog box.