How to Change Pivot Table Source Data

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: BananaStock/BananaStock/Getty Images

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.

Advertisement

Microsoft Excel 2007

Video of the Day

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.

Video of the Day

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.

Advertisement

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.

Advertisement

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.

Advertisement

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.

Advertisement

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.

Advertisement

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.

Advertisement

Advertisement

references