PivotTable Drill
Exercise 8: Reflect a source data fix
Task
The amount in row 4 of the source data (Chicago, Smith) was corrected from 9,000 to 19,000. Update the PivotTable.
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| Johnson | 33500 |
| Smith | 57500 |
| Williams | 45500 |
| Grand Total | 136500 |
The amount in row 4 of the source data (Chicago, Smith) was corrected from 9,000 to 19,000. Update the PivotTable.
This drill is for computer screens. On a phone you can review the steps.
- Right-click inside the PivotTable > Refresh
- Another way: Alt + F5
Key takeaway
A PivotTable doesn't update when the source changes. Refresh it after edits.
See Pivot Tables for details.