Pivot Table Drill Down

Pivot Table Drill Down

Post by John Kise » Fri, 02 Jan 2004 01:48:04


When I double-left click on a cell in a pivot table, I can
drill down and see the underlying data; however, it shows
me this data in another worksheet. To close my view of
the data, I have to remove that worksheet by deleting it.

For a lot of drilling down, that's a lot of time and
keystrokes.

Question...have I missed an easier method of closing the
drilled-down data worksheet?

Thanks
 
 
 

Pivot Table Drill Down

Post by Debra Dalg » Fri, 02 Jan 2004 12:24:39

AFAIK, there's no other way to view the detail. You could save the
worksheet before you start drilling, view the detail, then close without
saving.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.yqcomputer.com/