Create new worksheets per pivot page field

  • Thread starter Thread starter CW
  • Start date Start date
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?
 
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)
 
Back
Top