Show Pages for Excel 2007 Pivot Tables

[Guest]

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]

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

 

[Guest]

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

 

[Peo Sjoblom]

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

 

[Debra Dalgleish]

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

 

[Stephane Bourgain]

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?