Why do Pivots display pivot item tick boxes that are not visible in the pivot?

Hi there,

I'm using Excel 2003 right now.

I was wondering why a pivot table will allow you to tick and untick pivot items that are not visible?

My pivot tables have a lot of data and someone may wish to only see the pivot items that are shown in the pivot table in its currrent view. Is there a way in VB to achieve this?

In my attached example when you suntick the Media 'TV' then look in the 'Channels' drop down you can still see the tick boxes for TV channels 'ITV' and 'TV_BBC1' (I know why they are still ticked, I'd just like them not to be visible).

I have a feeling this is not possible but thought I'd ask the experts. Is it possible in Excel 2007?

Regards
Davellll

No, it's the same in both versions. If it worked the way you describe, it would actually be quite annoying when changing back and forth between filters since you would have to clear all the existing ones in order to see all the available values for a field.
2010 has added slicers though, which will make this much better.

Sounds to me like you'd be better off changing the source data for the pivot table instead. Then the only items available would be the correct ones.