Hello,
I have been using Pivot tables to work with changing data for a while and
all seems to work ok, except.... Historical references are still available in
the pick lists within the table.

No amount of refreshing helps and I have removed the field, refreshed and
put it back, but nothing seems to shift the old data.

This is causing problems with the users who go into the "Client" list and
have to scroll through people they know aren't there.

Will somebody please help?