Excel Pivot Table Problem

[Doug Fast]

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

 

[Toby Erkson]

I would recommend clicking on the drop-down arrow, deselect "Show All", then
only click on the regions you want to see, then click on the OK button when
done. I'm guessing that your method, selecting ALL afterwards, could be the
confusion.

The above method is how I do it for my pivots and never have had a problem.