refresh in pivottable

K

Kanan

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
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany
Kanan said:
I have a problem during refresh in my pivot table. In one of the
Click to expand...
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
Click to expand...
field. How do I get rid of them? I don't want to manually hide them or
delete them.
 
K

Kanan

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
 
Top