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?

The way pivot tables work changed in XL2002. What you are looking for is Show
Pages which you can find on the "Pivot Table Tool Bar" under PivotTable -
Show Pages. It is no longer on the right click menu where is was in XL2000...
--
HTH...

Jim Thomlinson


" wrote:

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?

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.



wrote:

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?

--

Dave Peterson

Please ignore this response.

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

Sorry.

Dave Peterson wrote:

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.

wrote:

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?

--

Dave Peterson

--

Dave Peterson

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.

Dave Peterson wrote:
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.



wrote:

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?

--

Dave Peterson

Right.

I misread the question. Read Jim's response.

wrote:

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.

Dave Peterson wrote:
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.



wrote:

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?

--

Dave Peterson

--

Dave Peterson

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.

wrote:
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.

Dave Peterson wrote:

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.



wrote:

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?

--

Dave Peterson




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html