In pivot tables you can actually (accidentall) overwrite the row and column
headings to the extent that they become "corrupt". i.e. the data field value
does not reconcile back to the pivot row/pivot column.

i.e. say you have dates running down the list, if I type over the labels, I
could not get the "original" labels back.

e.g. if the date is 01/21/2006 and I overtype it to 02/21/2006

How can I get the right labels back?
I have tried refreshing the pivot table, refreshing the pivot cache and
using the following code from contextures to no avail. The label simply does
not budge.
Short of recreating the pivot table again, is there anything else I can do?

http://www.contextures.com/xlPivot04.html#Clear2002

Sub DeleteMissingItems2002All()
'prevents unused items in non-OLAP PivotTables

'in Excel 2002 and later versions
'If unused items already exist,
'run this macro then refresh the table
Dim pt As PivotTable
Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.PivotCache.MissingItemsLimit = xlMissingItemsNone
pt.PivotCache.Refresh
Next pt
Next ws

End Sub