Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Table - Simultaneous Drill-Down

In a Excel Pivot Table, when we double-click a cell in the Data area,
a new sheet is created with the details.

What I want to do (I already did it in the past), is when I click a
cell in the Row area, several sheets are created (one per distinct
value).

I already had this feature in Excel in the past (I think it was an add-
on), but I don't remember how to find it or to do it again.

Thxs,,

Pedro Valente
Reply
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
Pivot table drill down In a quandry Excel Discussion (Misc queries) 0 November 12th 07 02:56 PM
Pivot Table drill down Beccy Excel Discussion (Misc queries) 1 March 1st 07 02:20 PM
Pivot table drill down formatting matelot Excel Worksheet Functions 1 May 11th 06 01:28 PM
Top 10 within a drill-down in a pivot table? ChrisBusch Excel Discussion (Misc queries) 8 June 2nd 05 08:36 PM
Automate Pivot Table Drill down tim Excel Worksheet Functions 0 April 5th 05 02:19 AM


All times are GMT +1. The time now is 02:50 PM.

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"