Hi
have a look at
http://www.contextures.com/xlPivot04.html

--
Regards
Frank Kabel
Frankfurt, Germany
"Kanan" schrieb im Newsbeitrag
...
I have a problem during refresh in my pivot table. In one of the
Pivot field called 'Category', I have the following list of values: A,
B,C,D,E and F. My base table data has changed for this month and
category C and E don't have any occurences.
After refresh , values C and E are still out there in the pivot
field. How do I get rid of them? I don't want to manually hide them or
delete them.

Please help
thanks
Kanan