Once you have created the Pivot Table, it does not automatically refresh when you add new data or change the existing data. Since your Pivot Table is created using the Pivot cache, when the existing data changes or when you add a new row or column to the data, the Pivot Table does not update itself automatically, and hence, the Pivot Table also does not update.
You have to need to force a refresh every time there are changes. Once you force a refresh, the Pivot Table Cache gets updated, which is reflected in the Pivot Table. This is the best option to refresh the Pivot Table when you enter the new data in the existing data. If you want to refresh the Pivot table then you have to follow the below steps.
Right-click on any cell of the Pivot Table and select the Refresh option.
This will instantly refresh the Pivot Table. You can also do this by selecting any cell in the Pivot Table and press the ALT+F5 shortcut key.
