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

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


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

Debra Dalgleish
Excel FAQ, Tips & Book List