Show Pages for Excel 2007 Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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?
 
Back
Top