K
Kiser
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
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