Create new worksheets per pivot page field

C

CW

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?
 
J

jxbeeman

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

ShaneDevenshire

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)
 
Top