Preventing new worksheets from being created by PIVOTdrill downs
 

Pivots are wonderful. I like that you can double click on something in the
data field and get a drill down of that data.

HOWEVER - it drives me nuts deleting all those extra worksheets that get
automatically created everytime I double click on the data just to take a
look.

Is there a way to prevent the creation of a new worksheet for a drill down,
unless I want it to stay in my workbook?

Thanks so much.