View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Valente Valente is offline
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