Pivot Table - Show Page Fields

S

SFrost

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

Debra Dalgleish

On the Pivot table toolbar, choose PivotTable>Show Pages

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