refresh in pivottable
 

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
thank
Kanan

refresh in pivottable
 

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

refresh in pivottable
 

thanks for the info
kanan

refresh in pivottable
 

Hi
Thanks for the info. Iam still not sure where I need to put that code to make it happen. Is there any predefined even
for this refresh operaion in EXCEL 2002. Or something else...
thank
Kanan