Suppose you have data table which looks like this:
Name Hours
James 3
Dave 4
James 5
David 2

and you form a pivot table from the data you will get three different names
(as you should). If you then realise that Dave and David are the same person
so you overwrite "Dave" with "David" in the source area, then when you
refresh the pivot table only two names appear, but if you click on the drop
down arrow in the pivot table field, the original name is still there even
though it no longer appears in the source table. The name also appears in the
pivot table if the "show data for empty rows" checkbox (or whatever it's
called) is ticked.

Is there anyway to get rid of that obsolete entry without redoing the entire
pivot table? I have tried loads of obvious tactics and none of them seem to
work.

Thanks,

Eric