Hit something weird today. We are making a lookup table to summarize a
lenghty list

EmpID
<no column
EmpBen EmpBenAtt

Layout is very important but just to give you an idea.

The concept we are after is they select the EmpID they want from the
drop down and it will give them a list of benefits for that employee.
Now since it is a long list and they're used to a text based system they
are typing the EmpID in. Most of the time this works well - but...

If they type something wrong they get a message "No item of this name
exists in the PivotTable report. Renmae 'X' to 'Y'?" And they hit OK.

At this point the PivotTable data in inaccurate. They've changed an
employee ID to something random and they don't remember what it is or
was (since we figure it out 3 days later).

I check the raw data that the pivot table is based upon and it's correct
- no changes made. So I do a refresh on the PivotTable and the messed
up data remains. I tried clearing Old items as oulined at
http://www.contextures.com/xlPivot04.html but that didn't make any
change.

So.. is there anyway to stop this behavior (protecting the sheet doesn't
work since it kills off needed functionality) OR how do I refresh the
data so that the correct data is displaying not the edited version?

I've only tried this in 2003 and have recreated with all data elements
in a PivotTable in 6 different spread sheets on 2 different computers
(way different models so I know it's not a image issue).


Hope that made sense...

Thanks,
PC_