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?


T.I.A.

Ed

Yes...the show all option started with XP.

"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?


T.I.A.

Ed

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

From a list of 100 integers (1-100), I want to select 20 numbers at
random without duplicating any numbers. From the list of the remaining
80 numbers, I want to create another array list of 20 numbers. And then
repeat this process until all 100 numbers are selected.

John Campbell