Whenever you do changes in the source data of the pivot table, you need to refresh in order to show the updated data. Here you can learn the way you can refresh the pivot table in excel.
There are two methods to refresh pivot table in excel. You can follow below screen shots to understand in clear cut manner.
1st Method:Please observe the below source data of the below pivot table. Source data row number is 12th and here we are going to add 2 lines of the data to find changes in the below pivot. Below pivot table row number also 12th before update data in the source data sheet.
In the above pivot table right click and you can find refresh option as shown in the below screen shot
Once refresh the data you can see updated data that 2 rows were increased in the below updated pivot table
2nd MethodIn the same pivot table we can go to data menu Refresh all option as you can find the refresh option.
Before refresh ensure that you have increased source data by click on option menu in the above screen shot. If you want to do the exercise you can download pivot table example excel file from our blog