Paul, and the pivot table expands as needed to accommodate. When we refresh the pivot table, we see a new row for St. Now let's change the City name from Minneapolis to St. The Pivot Table recalculates the original values. Let's change the total back to $87, and refresh again. When we refresh the pivot table, notice that the Minneapolis number shown in 2011 increases by $5,000, along with the subtotal for the Midwest, and the Grand Total for all regions. Let's increase the total sale value by $5000. The first row in the data shows a sale to a customer in Minneapolis in 2011. To illustrate how this works, let's change some source data, and then refresh the pivot table.
However, because the pivot table is itself constructed from the source data, the table itself might also change. When you Refresh a pivot table, it's important to understand that the only thing changing is data running through the pivot table. If the source data has not changed since the last refresh, the pivot table will not change. This causes Excel to reload the source data and display the latest information in the pivot table. The easiest way to update a pivot table manually is to right-click anywhere in the table and choose 'Refresh' from the menu. When you refresh a pivot table, you are simply asking Excel to update the Pivot Table based on the latest source data. To update a pivot table, you need to “refresh” it. Pivot tables do not automatically update when the source data is changed.