Pivot Table Drill into Details

S

stevedemo77

I have a pivot table with 155 values and the count for each value. I know
that by double clicking on the count in the data area the details will open
in a new worksheet. Is there a way to do this for all 155 values at once and
have the tabs named after each value, rather than having to double click on
all 155 of them then go and rename all the worksheet tabs? This would be a
huge time saver if there's a trick.

Thanks!
 
J

Jim Thomlinson

What you can do is to move the field with the 155 values to the page filter
at the top of the sheet. Now add all of the necessary details to the row
column and data sections. Depending on your version of XL you can access the
Show pages by

XL2000 or earlier
Right click on the page filter and select Show Pages

XL2002 or later
Select pivot table | Show Pages from the pivot table toolbar.
 
S

stevedemo77

Perfect! Thank you Jim.

Jim Thomlinson said:
What you can do is to move the field with the 155 values to the page filter
at the top of the sheet. Now add all of the necessary details to the row
column and data sections. Depending on your version of XL you can access the
Show pages by

XL2000 or earlier
Right click on the page filter and select Show Pages

XL2002 or later
Select pivot table | Show Pages from the pivot table toolbar.
 
S

stevedemo77

Works great...is there a way to do this and just create the other pages with
the data and not as pivot tables?

Thanks!
 

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

Top