If you remove or change data in the pivot table’s source, then refresh the pivot table, those old items might still appear in the drop down lists.For example, after the Central region is merged with the East region, it still appears in the Region heading drop down, even though all the sales records were changed. Tip: change your data set to a table before you insert a pivot table. On the Analyze tab, in the Data group, click Change Data Source.Refresh pivot table on file open Options in the Pivot Table group. Then in the Pivot Table Options dialog, click Data tab, and then check Refresh data when opening the file. Click OK, then if the original data has been changed, and when you opening this file next time, the pivot table will refresh automatically.Tip: In Excel 2013, you need to click Analyze tab in step 1.To do this, select a cell in the Pivot Table, display the Options tab of the ribbon, click the Change Data Source tool in the Data group, and finally choose Change Data Source. Make sure the cell range in the Table/Range field reflects accurately the range you want included in the Pivot Table.
Refresh the pivot table or change the data source to update the pivot table with the applied changes.
If you change any of the text or numbers in your data set, you need to refresh the pivot table.
If you change the size of your data set by adding or deleting rows/columns, you need to update the source data for the pivot table. This way your data source will be updated automatically when you add or delete rows/columns.
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.