Pivot table fields can be edited and renamed by mistake quite easily. Where
this has been done, I am having trouble re-writing the correct values to the
pivot table, despite the fact that the database containing the data, still
shows the correct data. I have tried refreshing the data, have looked at all
the pivot table options and tried changing the field settings without success.

I am using Microsoft Excel 2003 SP1