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?

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