Preventing extra Worksheets when drilling down in Pivots?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

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

Similar Threads

Pivot table drill down data 2
Preventing new worksheets when drilling down in PIVOTs 2
Pivot Chart Drill-Down 1
Pivot table - drill down - format 0
drill down worksheet placement (pivot tables) 1
Pivot Table - Drill down to source and update 1
Pivot Table drill down 1
Pivot Table: Resulting Column Widths on Drill Down 0

Back
Top