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?
 
Try double clicking (left mouse button) on the information that your
interested in
JX
 
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)
 
You must log in or register to reply here.

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

Pivot table results error 1
Pivot table creation in excel 1
Calculated Item in Pivot table 1
use field data from 1 pivot table in another? 1
Excel VBA For excel 0
Pivot Table Show Pages On Same WorkSheet 6
linked 3 pivot table pages ????? 1
Pivot using 250,000 rows of data in Excel? 1

Back
Top