Create new worksheets per pivot page field
 

In an earlier version of Excel I could right click in a pivot table and a
command like "show pages" was available. It automatically created a new
worksheet for each entry in the selected page field?

Does this still exist in Excel 2003?

Create new worksheets per pivot page field
 

Try double clicking (left mouse button) on the information that your
interested in
JX

Create new worksheets per pivot page field
 

Just double click on the data desired
jx

"CW" wrote:

In an earlier version of Excel I could right click in a pivot table and a
command like "show pages" was available. It automatically created a new
worksheet for each entry in the selected page field?

Does this still exist in Excel 2003?

Create new worksheets per pivot page field
 

Hi CW,

I think the answer you are getting is for Drill down not Show Pages. In
2003 choose the command Pivot Table, Show Pages. (on the pivot table toolbar)
--
Thanks,
Shane Devenshire


"CW" wrote:

In an earlier version of Excel I could right click in a pivot table and a
command like "show pages" was available. It automatically created a new
worksheet for each entry in the selected page field?

Does this still exist in Excel 2003?