Pivot Table "Show All" Check Box missing in Excel 2000

Hope someone can help with this.

A large array of data I have is sorted and filtered using
a pivot table. Works well in XL2002 & XP, being able to
uncheck the show "ALL" box in the Pivot Table drop down
menu and then choosing only the category(ies) I want to
view.

However, when loaded on an Excel 2000 machine, the show
ALL box is not listed, only the individual choices.
Obivously to uncheck 100 options to view only 1 is not
going to work. Anyone have an explanation?

Appreciate any help in advance.

Curtis

You can use a macro to hide or show the items -- there's some sample
code on my web site:

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

wrote:
A large array of data I have is sorted and filtered using
a pivot table. Works well in XL2002 & XP, being able to
uncheck the show "ALL" box in the Pivot Table drop down
menu and then choosing only the category(ies) I want to
view.

However, when loaded on an Excel 2000 machine, the show
ALL box is not listed, only the individual choices.
Obivously to uncheck 100 options to view only 1 is not
going to work. Anyone have an explanation?


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

Thank you. That works really well. I'm assuming w/ a
little more code I could add a drop down to the "Show"
or "Hide" one item code that would list what items I have
available top choose from (they will always stay the
same)? If you happen to know that code too, I'd
appreciate it, otherwise I can figure it out.

Thanks again!

Curtis
-----Original Message-----
You can use a macro to hide or show the items -- there's
some sample
code on my web site:

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

wrote:
A large array of data I have is sorted and filtered
using
a pivot table. Works well in XL2002 & XP, being able
to
uncheck the show "ALL" box in the Pivot Table drop down
menu and then choosing only the category(ies) I want to
view.

However, when loaded on an Excel 2000 machine, the show
ALL box is not listed, only the individual choices.
Obivously to uncheck 100 options to view only 1 is not
going to work. Anyone have an explanation?


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

.