Displaying pivot table detail
 

I would like to display details in pivot table without opening a new
worksheet. I can do this in access but excel forces me to open new
worksheets. Any ideas?

Displaying pivot table detail
 

Drill to details sends the data to a new worksheet, and there's no
setting you can change to prevent it.

Coop@nationwide wrote:
I would like to display details in pivot table without opening a new
worksheet. I can do this in access but excel forces me to open new
worksheets. Any ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html