Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Help
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |