I have created a pivot table in which I am frequently
adding and deleting information from the pivot data
source. After refreshing the table, the updates are
reflected. HOWEVER, if the field I am working with is
part of the LAYOUT area (Row or column) and I choose to
select only some of the data from the field, it shows a
list of all data that has ever been a part of the data.
So, even though for example, I deleted the name Jon Doe
from my pivot data source field called 'Names', it remains
one of the 'Names' that I can choose to display. Of
course, if I do choose Jon Doe, the name is not shown in
the report and no data for him is shown either.
Ironically, if I Pivot Drag the field to the PAGE area, my
choices are '(All)' or any of the names that have data.
Jon Doe will not even be a choice.

IS THERE A WAY TO REVISE THIS? IN OTHER WORDS, I WOULD
LIKE IT IF WHEN I HIT REFRESH THAT THE CHOICES FOR 'NAMES'
FROM THE LAYOUT AREA DOES NOT REFLECT NAMES THAT HAVE
SINCE BEEN REMOVED FROM MY PIVOT DATA. CAN THIS BEEN
DONE? HOW?

Please help!

Ken Roberts
617 951 7494