Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drill into Details
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drill into Details
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. -- HTH... Jim Thomlinson "stevedemo77" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drill into Details
Perfect! Thank you Jim.
"Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "stevedemo77" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drill into Details
Works great...is there a way to do this and just create the other pages with
the data and not as pivot tables? Thanks! "Jim Thomlinson" wrote: 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. -- HTH... Jim Thomlinson "stevedemo77" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting drill to details | New Users to Excel | |||
Pivot Table Drill Down | Excel Discussion (Misc queries) | |||
Drill to Details - is there user friendly way to delete the sheet | Excel Worksheet Functions | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Format Drill to Details Table | Excel Discussion (Misc queries) |