This article explains how you can add new data to an existing Microsoft Excel PivotTable. You can perform this change on both a Windows and a Mac computer.
Steps
Step 1. Open the Excel file which contains the pivot table
Double-click the document icon to open it directly in Excel.
Step 2. Select the sheet where the data is stored
Click on the tab that contains the data to update (for example Sheet2) displayed at the bottom of the Excel window.
Step 3. Add new data or edit existing ones
Enter the data you want to add to the pivot table directly below or next to the existing data.
-
For example, if current data is stored in cells from the A1 at the E10, you can insert the new ones starting from the column F. or from the line
Step 11..
- If, on the other hand, you simply need to modify the existing information in the pivot table, do so.
Step 4. Go to the tab where the pivot table is stored
Click on the label of the sheet in which you created the pivot table.
Step 5. Select the pivot table
Click on the table to select it.
Step 6. Click on the Options tab or Analyze.
It is located in the center of the green Excel ribbon. A new toolbar will appear.
If you are using a Mac, click on the tab Analyze Pivot Table.
Step 7. Click the Change Data Source icon
It is located in the "Data" group of the tab Options or Analyze on the Excel ribbon. A drop-down menu will appear.
Step 8. Click the Change Data Source… option
It is one of the items listed in the drop-down menu that appeared. A dialog box will appear.
Step 9. Select the data
Click on the cell in the upper left corner of the data range to be analyzed, then drag the mouse cursor to the cell in the lower right corner of the set. The new columns or rows of data you have added will also be included within this selection.
Step 10. Click the OK button
It is located at the bottom of the window.
Step 11. Click the Update icon
It is located in the "Data" group of the tab Options or Analyze on the Excel ribbon.
