How do you refresh a pivot table – Excel Formula

0
Refresh Pivot Table
Refresh Pivot Table

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.

Pivot table data source to show pivot table option in excel
Pivot table data source to show pivot table option in excel

 

Pivot table before update
Pivot table before update

In the above pivot table right click and you can find refresh option as shown in the below screen shot

Refresh by right click on pivot table
Refresh by right click on pivot table

Once refresh the data you can see updated data that 2 rows were increased in the below updated pivot table

Updated pivot table after source data update
Updated pivot table after source data update

2nd MethodIn the same pivot table we can go to data menu Refresh all option as you can find the refresh option.

Refresh option by clicking on data menuu
Refresh option by clicking on Data menu

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

More about refresh pivot

Summary
How do you refresh a pivot table
Article Name
How do you refresh a pivot table
Description
Here you can learn the way how you can refresh pivot table in excel
Author
Publisher Name
Excel-Formula
Publisher Logo

LEAVE A REPLY

Please enter your comment!
Please enter your name here