| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
If you're using Excel 2000, or an earlier version, the Show All checkbox
isn't available. 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 OwenLiu wrote: I am facing the same problem and hope soneone can provide the method to display the "Show All" checkbox. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel XP Pivot Table in Excel 2000 | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
| Pivot table : Excel cannot complete this task with available resou | Excel Worksheet Functions | |||
Threaded Mode
