Pivot Tables

  • Thread starter Thread starter Jkiser
  • Start date Start date
J

Jkiser

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?

Thanx

..
 
#1. I don't think so. But maybe you could apply Data|filter|autofilter to the
original data. Sometimes you can apply filters quicker than creating the new
sheet (and possible reformatting) and then deleting.

#2. What happened when you tried it?

..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
(It didn't get refreshed when I tried it in xl2002.)
 
Back
Top