After you create a Pivot Table, you can change the range of its source data.For example, you can expand the source data to include more rows of data.Even after you refresh the pivot table, the name of the old region might continue to appear in the drop down lists, along with the new names.In the list below, the Central region still appears in the list.This is a very useful function, but you might prefer to have a simple link most of the time.To fix this, you can change an Excel setting, so the Get Pivot Data formula doesn’t appear automatically.This pivot table tutorial shows how you can clear the old items either manually or programmatically.NOTE: There is also a Clear Old Items feature in my Pivot Power Premium add-in, along with many other time-saving pivot table tools.
Refresh the pivot table or change the data source to update the pivot table with the applied changes.
To fix this, you can change a pivot table setting, so no old data is stored in the pivot cache.
If you try to link to a value cell in a pivot table, a Get Pivot Data formula appears, instead of a simple link.
You can also refresh data from a source table in the same or a different workbook.
And you can set your workbook to refresh its Pivot Table data automatically when you open it.