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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Show The Difference From Previous Months With Exce... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...