Pivot Tables - Drill Down

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top