Pivot Table - Show Page Fields

G

Guest

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.
 

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
Different ways to build Pivot table 1
Pivot Table - Changes 5
How do I add extra data to a pivot table? 3
Pivot Table Page Break Refresh Problem 0
Access #Error & Excel Pivot 0
Are copied Pivot Tables "linked" to each other ? 2
Pivot Table Fields 1

Top