Here is the issue,

I have four sales areas. (East, West, North, South) in a drop down for
my pivot table, which has data.

Now I want to see what the South-East is doing. So I hide West and
North for my drop down and then select "ALL" in my region.

It shows the two sales area I wanted. --YEAH --

So here is the issue sometimes, when I refresh my data I see all four
areas even though it still shows North and South as hidden.

I can rebuild the pivot table from the source (MS SQL) and do the
hiding again, and it works.

This problem is sparatic. Sometimes it works and other times it
fails. (Once it has failed - I have to rebuild.

So why is it doing it? How can I prevent this? I have standard
reports people pull up and refresh, I need a consistant way to have
this work, with out adding indicators for every possible combination.

Any Ideas?

Doug Fast