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?

There are instructions here for clearing old items from a pivot table:

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


Janet BN wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you very much Debra - that has been giving me a headache for a while
and your solution worked perfectly.



"Debra Dalgleish" wrote:

There are instructions here for clearing old items from a pivot table:

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


Janet BN wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

You're welcome! Thanks for letting me know that it helped.

Janet BN wrote:
Thank you very much Debra - that has been giving me a headache for a while
and your solution worked perfectly.



"Debra Dalgleish" wrote:


There are instructions here for clearing old items from a pivot table:

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


Janet BN wrote:

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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html