Pivot Tables Refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Thank you very much Debra - that has been giving me a headache for a while
and your solution worked perfectly.
 
Back
Top