Show Pages for Excel 2007 Pivot Tables
 

Where do I find Show Pages on the Excel 2007 Ribbon?

In earlier versions of Excel, this feature was extremely useful to
automatically create a new Worksheet for each unique value of the field in
the Pages (Report Filter) section of a Pivot Table. It seems unlikely that
this feature would be left out of the new version.

Jim

Show Pages for Excel 2007 Pivot Tables
 

Select a cell in the pivot table
On the Ribbon, click the Options tab
At the far left, click the dropdown arrow for Options
Click Show Report Filter Pages


Jim Georgia wrote:
Where do I find Show Pages on the Excel 2007 Ribbon?

In earlier versions of Excel, this feature was extremely useful to
automatically create a new Worksheet for each unique value of the field in
the Pages (Report Filter) section of a Pivot Table. It seems unlikely that
this feature would be left out of the new version.

Jim


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

Show Pages for Excel 2007 Pivot Tables
 

Thanks very much. I wish there were a document called "How to transition
from Pivot Tables in Excel 2003 to Pivot Tables in Excel 2007.

Jim

"Debra Dalgleish" wrote:

Select a cell in the pivot table
On the Ribbon, click the Options tab
At the far left, click the dropdown arrow for Options
Click Show Report Filter Pages


Jim Georgia wrote:
Where do I find Show Pages on the Excel 2007 Ribbon?

In earlier versions of Excel, this feature was extremely useful to
automatically create a new Worksheet for each unique value of the field in
the Pages (Report Filter) section of a Pivot Table. It seems unlikely that
this feature would be left out of the new version.

Jim


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

Show Pages for Excel 2007 Pivot Tables
 

Maybe you should ask Debra for that, not only did she write a great pivot
cook book she also has a great website and wrote an introduction to pivot
tables that can be found here

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm



--
Regards,

Peo Sjoblom





"Jim Georgia" wrote in message
...
Thanks very much. I wish there were a document called "How to transition
from Pivot Tables in Excel 2003 to Pivot Tables in Excel 2007.

Jim

"Debra Dalgleish" wrote:

Select a cell in the pivot table
On the Ribbon, click the Options tab
At the far left, click the dropdown arrow for Options
Click Show Report Filter Pages


Jim Georgia wrote:
Where do I find Show Pages on the Excel 2007 Ribbon?

In earlier versions of Excel, this feature was extremely useful to
automatically create a new Worksheet for each unique value of the field
in
the Pages (Report Filter) section of a Pivot Table. It seems unlikely
that
this feature would be left out of the new version.

Jim


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

Show Pages for Excel 2007 Pivot Tables
 

And her new book, on Excel 2007 pivot tables, should be out in a couple
of weeks. I hear it's great! <g

http://www.contextures.com/Pubn03.html

Peo Sjoblom wrote:
Maybe you should ask Debra for that, not only did she write a great pivot
cook book she also has a great website and wrote an introduction to pivot
tables that can be found here

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm





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

Show Pages for Excel 2007 Pivot Tables
 

I have just upgraded from Office 2003 to 2007, and have always had an intense
use of the "show pages" function.
It appears that the 2007 doesn't work quite the same.
In 2003, if your field description were superior to 30 (the maximum letters
you can input for a tab) it would cut the longer description so it can fit
the tab restrictions.
In 2007, it doesn't and shows an unpleasant "SheetXXX" instead.

Does anyone have an idea to get back that function?