Pivot Table Show Pages missing from Excel XP

D

Don

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.
 
D

Don

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Tables 1
Show Pages for Excel 2007 Pivot Tables 5
pivot table source data expand to new entries when refresh? 4
pivot table data 2
How do I find the "Show Pages..." Pivot table feature in 2007? 1
Access #Error & Excel Pivot 0
Pivot Table 2

Top