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!

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!

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!

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!