Where did "Show All" go?

F

fuqua_megan2

I created a pivot table using Excel 2003. In the Row Fields drop down
I have a "show all" button. When I email the pivot table to another
person who is also using 2003 that person does not have the "show all"
option.

Is there a way to bring this feature back?
 
D

Dave Peterson

There's no "Show All" option in that filter list. There is an "(All)" option,
though.

My bet is that the recipient has to scroll up to the top of the list to see that
option.

By the way, you can add a "Show All" button to your favorite toolbar (especially
handy if you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.
 
D

Dave Peterson

Please ignore this response.

I read it as a question about data|Filter|autofilter.

Sorry.
 
F

fuqua_megan2

Thanks,

This isn't quite what I was looking for - maybe I am using the wrong
terminology though. I definately have a check box within by pivot
table that allows me to show all which then adds a check box to each of
the items I want to include in pivot and when I click it again it
deselects everything so I can pick and choose which rows I want to
show.

I will keep researching.
 
D

Debra Dalgleish

Are you sure that the other person is opening the file in Excel 2003? Do
they see the Show All option in other pivot tables?
If they're opening it in Excel 2000, the Show All feature won't be
available.

Thanks,

This isn't quite what I was looking for - maybe I am using the wrong
terminology though. I definately have a check box within by pivot
table that allows me to show all which then adds a check box to each of
the items I want to include in pivot and when I click it again it
deselects everything so I can pick and choose which rows I want to
show.

I will keep researching.
Click to expand...
 
Top