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