Piviot Tables

[TO]

I have a few piviot tables that work off a large data
table.

one of the fields I use is "Acct #s" I have about 200
different acct #s. I one piviot table I only need to
show 2. Is there a way to unselect (uncheck) all the
account #s in the drop down so I can go back and just
check the two I need.

Thanks in Advance

 

[Debra Dalgleish]

There are sample macros here that you can use to show or hide the items
in a field:

Excel -- Pivot Tables -- Show and Hide Items
http://www.contextures.com/xlPivot03.html