Learn

Unlike formulas, pivot tables in Excel do not update automatically if the original table changes. There are two methods for updating a pivot table manually, depending on how the original table has changed:

  1. Refresh: if the size and location of the source dataset have not changed, select Refresh from the PivotTable Analyze tab.
  2. Change data source: if the size and/or location of the source dataset have changed, select Change Data Source from the PivotTable Analyze tab and select the new source range.

Note that the PivotTable Analyze tab will only appear if you have selected a cell within the pivot table.

We’ve placed a slideshow illustrating both cases in the Learning Environment. When you’re ready to try this yourself, get started on the next set of instructions!

Instructions

When you’re ready to practice what you’ve learned, download and work through our interactive exercise spreadsheet.

If you get stuck, feel free to download our solutions spreadsheet!

Reflection Question: What happens if the layout of a table changes and you update a pivot table?

Our Answer
As long as the columns used in the pivot table setup still exist, the pivot table will update. If the columns used in the pivot table don't all exist or don't all have the same names, then the pivot table will no longer work.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?