How to Add Data to a Pivot Table

1. Double-click the Excel file that contains your PivotTable to open it with Excel 2010.
2. Navigate to the source data for the PivotTable. This may be in a separate area of the worksheet, or on a separate worksheet. If your data is on a separate worksheet, you can chance worksheets by clicking on the correct worksheet tab at the bottom of the window.
3. Add your desired row or column of data. You can also modify the existing data, if you need to.
4. Navigate to your PivotTable and select any cell in the table. Click the 'Options' tab at the top of the screen, and then click the 'Change Data Source' button. Excel 2010 will automatically move to your source data and open a 'Move PivotTable' window.
5. Click on the top-left cell in your source data, and hold the mouse button as you drag the mouse to the bottom-right cell. Then release the mouse button and click 'OK' on the 'Move PivotTable' window. The PivotTable will now update to include the added data.