View Single Post
  #1   Report Post  
STILLA
 
Posts: n/a
Default Preventing new worksheets when drilling down in PIVOTs

(sorry, forgot to mention that this is about Pivot tables)

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?

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

Thanks so much.