How to Update a PivotTable Using a Cell Reference

1. Open the PivotTable you want to change.
2. Click on a cell within the PivotTable you want to update.
3. Run the PivotTable and PivotChart Wizard by clicking on the 'Tools' menu and then selecting 'PivotTable and PivotChart Wizard.' It automatically takes you to the wizard for your PivotTable.
4. Skip Step 1 and go directly to Step 2. This step allows you to redefine the cell reference for the source data. Input the new cell reference in the box for source data and click 'Next' and then select 'Finish.' The PivotTable automatically updates with the new data in the new cell reference.