Pivot Table Drill Down

[John Kiser]

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

 

[Debra Dalgleish]

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.