Update Pivot Table in Excel

Update Pivot Table

Any update that you have made in the original data set may not be updated automatically. By default whenever you open your Pivot Table it does not get refreshed automatically. – Update Pivot Table

Refresh Pivot Table

For refreshing your Pivot Table or update Pivot Table you need to refresh your Pivot Table every time you open the Pivot table document. To update changes in the Pivot table that was made in the data set follow this steps :

Method 1

Step 1Right-Click on any cell inside the Pivot table

Step 2Select the refresh option from the drop-down

Update Pivot Table - Refresh

Method: 2

Step 1Click anywhere inside the Pivot table

Step 2Press Alt +F5

Method: 3

Step 1Click anywhere inside the Pivot Table

Step 2In the Pivot Table tool option, Click in Analyze , Data Group > Click on Refresh.

update Pivot Table - Refresh_analyze

TIP: To refresh all the Pivot Table in the workbook, click on Refresh All.

These are the three method through which you can refresh any changes that are made in the form of text or number in the data set.

Change the Data Source – Update Pivot Table

Changes that are made in the original data like adding or deleting a row or column, for that you need to update your Pivot Table as well. You can update for Pivot Table for the required changes that are made in the Source Data by following the steps below:

Step 1Click anywhere inside the Pivot Table to activate the Pivot Table.

Step 2In the Pivot Table tool option, Click in Analyze , Data Group > Click on Change Data Sources

update Pivot Table - Change Data source

Step 3In the Change Source Data dialog box, Enter the range you want to use to make Pivot table

update Pivot Table - Change Data source Dialog box

TIP: In order to avoid mess of changing the data again and again, you must convert your original data or the Source data into table. Creating a table will automatically update your Pivot table.

Change Pivot Table settings to Refresh your Pivot Table whenever you open the file

When you change the Data set it automatically does not get updated in the Pivot table. You can change this default setting. This setting will update your Pivot Table as and when you Open your Pivot Table file. Steps to change the settings are:

Step 1In the Analyze tool, Pivot table group > Click on the Options.

update Pivot Table - Options

Step 2Pivot Table dialog box pops up. In the Data tab, Click or put a tick on the option “ Refresh Data when opening the file”.

update Pivot Table - Refresh Data

Step 3Click OK. After you have enabled this option, everytime you make changes to the original data set and you open this file it will automatically get updated. – Update Pivot table

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.