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