When the information in your data set gets updated you need to Refresh your Pivot Table to see those changes in your Pivot Table.  There are three ways to do this.  First click on your Pivot Table and:

1. From the Ribbon choose: PivotTable Tools > Options > Refresh

2.Press ALT+F5

3.Right click in your Pivot Table and choose Refresh (see this option below)

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Change the information in your data set.

 

STEP 2: Click in the Pivot table.

 

STEP 3: Right click and select Refresh.

The Pivot Table values are now updated!

Refresh a Pivot Table

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Top 3 Excel Pivot Table Issues Resolved I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.I want to put these issues to bed so you can go o...
Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below:You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10.W...
Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere!Let us start off with this Excel Pivot Table showing the Sum of SALES for...
Filter a Pivot Table by Dates There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due...