In Excel 2000, and earlier versions, the Show All checkbox isn't
available. You can use programming to hide or show the items -- there's
sample code he

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

Grant wrote:
I running Office 2003. I created a Pivot Table and passed it along to
another user who is running 2000. I have some sales by account. My account
numbers are added to "Row Area". When I click on "Account" drop down list I
see all my accounts listed plus I have an option to check/uncheck a "Show
All" box. The user running 2000 does not have this option of a Show All
check box. Is this a version issue or is there an option that makes this
happen?


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