Pivot Tables - Drill Down

Pivot Tables - Drill Down

Post by Kise » Wed, 29 Oct 2003 00:35:07

When I double click to drill down to the supporting data
in a pivot table, the data is displayed on a new tab
within the workbook. Then to close that data, I have to
delete the tab.

Two questions....

1) Is there a faster way to view then close the data
without having to delete a tab every time?

2) If I leave the new sheet open, is it linked to the
pivot table? In other words, if I refresh the pivot
table, will the data on the new sheet be automatically
refreshed as well?


1. Pivot table "drill down to data"

2. Pivot Table Drill Down

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?


3. Pivot Table drill down and 256 character limit

4. Pivot Table drill downs

5. Excel drill-down pivot table

6. Pivot Table: Resulting Column Widths on Drill Down

7. Pivot Table - Simultaneous Drill-Down

8. Pivot Table macro to set print area and print details of drill down data

9. Pivot Table - Simultaneous Drill-Down

10. How do I change a pivot table report to sort when I drill down

11. Pivot Table - Trigger event on drill down

12. drill down worksheet placement (pivot tables)

13. URGENT Drill down in pivot table

14. Top 10 within a drill-down in a pivot table?

15. Drill down pivot table data via VBA macro