Refresh All for Excel Pivot Tables
If you want to see the changes in your Pivot Table, when the information in your data source gets updated or changed then you need to Refresh your Pivot Table. However, if you are having Pivot Tables that are created from two different data sources in the same workbook or multiple Pivot Tables from the same data source in the same workbook then you simply need to select that Data and then need to Refresh All and automatically all your Pivot Tables will get updated in just a click.
Follow these steps to refresh all in your Excel:
STEP1: Change The Values
Firstly, make all change whatever information you want to add in your data set.
STEP2: REFRESH ALL for Pivot Table
Below given Pivot Table is my example to show you, now Take note of the cell that I need to update:
Just Go to Data > Refresh All
Here, you got your updated Pivot Table values with just one click.