This is a limitation of the Google Sheets pivot table features. If the Pivot table uses filters, your data is not going to get updated when original data values are changed. To do away with this, you can add a filter to the table that filters out blank rows and displays only those rows that contain a value. When you have blank rows in your original dataset, your Pivot table will also show one blank row, which might not look very good. Note: There is a small disadvantage to this method. Now, as long as your data is within the 1000 rows, the Pivot table will get automatically refreshed. The extra 980 rows can remain blank, and you can later fill them in with data as and when required. When initially creating your pivot table you can use a little foresight and add some extra rows for data you are likely to add in the future.įor example, if your data currently spans over 20 rows, you can create your pivot table with 1000 rows. If the new row you are trying to add is not within the Pivot table’s range, it will not have any effect on the Pivot table.Īnd that obviously makes sense, since the new range does not fall into the range that the Pivot table was built to pull data from. The Pivot table works with data from a particular range of cells in your original worksheet. Problem 1: Pivot Table does not refresh when adding a new row
#How to reset excel pivot chart data range how to#
Let us take a look at each of the above situations, why they happen, and how to solve them one by one. Your dataset may contain formulae that need to get re-calculated, like RANDOM, TODAY, etc.You may be adding new data to rows outside the Pivot Table range.If you find that your Pivot tables are not getting refreshed automatically whenever you make changes to the original dataset, it may be due to one of the following reasons:
Why does the Pivot Table not get Refreshed? In this tutorial, we will take a look at some of those situations and how to correct them, so that changes to your original data get updated in the Pivot table too. However, there may still be situations where you find the data in the Pivot table not getting updated. They get automatically refreshed when the data being pulled by the table gets changed. In general, Pivot tables don’t need to be manually refreshed. How to Refresh Pivot Table in Google Sheets