Pivot Table Show Pages missing from Excel XP
 

I used to use the "Show Pages" function on my Pivot tables in Excel before
but now I have been upgraded to Excel 2007. Has this option gone away as I
can not find out how to do this now.

Pivot Table Show Pages missing from Excel XP
 

found it, happy guy

Select a cell in the pivot table
On the Ribbon, click the Options tab
In the PivotTable group, click the dropdown arrow for Options
Choose Show Report Filter Pages
Select a filter, and click OK



"Don" wrote:

I used to use the "Show Pages" function on my Pivot tables in Excel before
but now I have been upgraded to Excel 2007. Has this option gone away as I
can not find out how to do this now.