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