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 :
Step 1: Right-Click on any cell inside the Pivot table
Step 2: Select the refresh option from the drop-down
Step 1: Click anywhere inside the Pivot table
Step 2: Press Alt +F5
Step 1: Click anywhere inside the Pivot Table
Step 2: In the Pivot Table tool option, Click in Analyze , Data Group > Click on Refresh.
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 1: Click anywhere inside the Pivot Table to activate the Pivot Table.
Step 2: In the Pivot Table tool option, Click in Analyze , Data Group > Click on Change Data Sources
Step 3: In the Change Source Data dialog box, Enter the range you want to use to make Pivot table
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 1: In the Analyze tool, Pivot table group > Click on the Options.
Step 2: Pivot Table dialog box pops up. In the Data tab, Click or put a tick on the option “ Refresh Data when opening the file”.
Step 3: Click 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.