Updating source data for pivot table
However, when you refresh the pivot table after making the changes, the renamed field will disappear from the pivot table layout.
In our example, the Qty field is removed from the layout.
The issue here is that a pivot table doesn't know if That is why you have to manually change the source cell reference and refresh pivot table, this is very easy to forget.
However this article solves your problems using an excel defined table and a small amount of event code.
Occasionally, you might need to change a column heading in the pivot table’s source data.
For example, you could change a column heading from Qty to Quantity, to make it easier to understand.
If you change the column headings, you’ll have to add the revised field to the pivot table layout again.
Works in Excel 2003 and earlier, and in Excel 2007 if you’ve installed the latest service packs.
What if the worksheet contains a pivot table and its sister pivot chart?
In a previous post: How to create a dynamic pivot table and refresh automatically I demonstrated how to refresh a pivot table when a sheet is activated.
This post describes how to refresh a pivot table when data is edited/added or deleted on a specific worksheet.
Search for updating source data for pivot table:
This guide assumes that you have already created a pivot table, but that you have recently updated the data that was used to generate the pivot table.