In Excel 2000, and earlier versions, the Show All checkbox isn't
available. You can use a macro to hide or show the items -- there's
sample code on my web site:

http://www.contextures.com/xlPivot03.html

DD1 wrote:
Can you please tell me if it is possible in Excel 2000 to uncheck or
de-select all items in the row field.
The reason being is that when a row field has 100s of items and you
only want to select a few of these items - it is very time consuming to
manually go through and uncheck all the ones that you don't want.
Excel by default has them all checked/ticked - and I would like to be
able to unchceck or de-select them all and then just select the one or
two that I want.
Is that possible?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html