Pivot Table - untick all items in row field

[DD1]

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]

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

 

[Gary Rowe]

Just uncheck the top check box called "(show all)" and all items will be
unchecked.
Gary

 

[Gary Rowe]

My apologies, I didn't catch the Excel 2000 reference.
Gary

 

[DD1]

Many thanks for answering that so quickly Debra. I really appreciat
your help

 

[Debra Dalgleish]

You're welcome! If you aren't familiar with using programming, there are
instructions here for copying the code to your workbook:

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

and David McRitchie has instructions for getting started with macros:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[rmm30]

I am having the same trouble.

I copied the code in to the workbook, but how do you use it?