How to Refresh a Pivot Table in Microsoft Excel to Reflect Data Change

When you update data in a Microsoft Excel spreadsheet, the change will not be automatically visible in an existing pivot table. It is necessary to update a refresh the pivot table to see the change.

In this video we'll look at how to make sure you are seeing the latest data.

Refresh Your Pivot Table in Microsoft Excel: A Quick Guide to Seeing the Latest Data
People often find that their pivot table doesn't see the inserted column.

To update our fresh a pivot table right click on the pivot table and then select "Refresh" from the drop down menu. The data showing in the pivot table will now reflect the data in your Microsoft excel spreadsheet.