LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting drill to details Deb New Users to Excel 0 September 2nd 08 09:00 PM
Pivot Table Drill Down EarlyBirdie Excel Discussion (Misc queries) 0 February 27th 08 06:07 PM
Drill to Details - is there user friendly way to delete the sheet Dave Excel Worksheet Functions 1 January 31st 07 04:06 PM
Pivot Table macro to set print area and print details of drill down data Steve Haskins Excel Discussion (Misc queries) 2 December 28th 05 04:59 PM
Format Drill to Details Table GillianHG Excel Discussion (Misc queries) 4 September 1st 05 03:37 PM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"