Pivot Table - Show Page Fields
 

In Excel 2000 in the Pivot function you could "Show Pages" in a Pivot Table
that would automatically put each unique page field on a separate tab in the
existing worksheet. I cannot find that function in Excel 2003. Does anyone
know if this still exists?
Thank you!

Pivot Table - Show Page Fields
 

On the Pivot table toolbar, choose PivotTableShow Pages

If you use the command frequently, you can add it as a button on the
PivotTable toolbar.

SFrost wrote:
In Excel 2000 in the Pivot function you could "Show Pages" in a Pivot Table
that would automatically put each unique page field on a separate tab in the
existing worksheet. I cannot find that function in Excel 2003. Does anyone
know if this still exists?
Thank you!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html