How to refresh data in a pivot table

Abstract

Transcript

Pivot tables do not automatically update when the source data is changed.

To update a pivot table, you gotta refresh it.

Let’s take a look.

This causes Excel to reload the source data and display the latest information in the pivot table.

If the source data has not changed since the last refresh, the pivot table will not change.

To illustrate how this works, let’s change some source data, and then refresh the pivot table.

The first row in the data shows a sale to a customer in Minneapolis in 2011.

Let’s increase the total sale value by $5000.

Let’s change the total back to $87, and refresh again.

The Pivot Table recalculates the original values.

Now let’s change the City name from Minneapolis to St. Paul.