How to Change Pivot Table Source Data

By Greg Lindberg

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.

Things You'll Need

  • Microsoft Excel

Microsoft Excel 2007

Step 1

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

Step 2

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 3

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

Step 4

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

Step 5

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 1

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

Step 2

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 3

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 4

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

Step 5

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