Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Preventing new worksheets when drilling down in PIVOTs
On the Pivot Table toolbar follow the path Pivot Table / Table Options.
Uncheck the enable drilldown button. Once you do this you will no longer be able to drill down "create sheets" until you re-check the button. If this is not what you want the only other option is to not save the workbook when you are done with it "looking at the data". Any changes you have made will not be saved including the new sheets you created. Hope this is a start. Thanks, Bill Horton "STILLA" wrote: (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. |
#3
|
|||
|
|||
Preventing new worksheets when drilling down in PIVOTs
Thanks William!
I was hoping there would be a way to actually look at the drill down data in a pop up or something, without an actual worksheet tab being created.. but I guess it's not possible. Your second option, of course, makes a lot of sense. Stilla "William Horton" wrote: On the Pivot Table toolbar follow the path Pivot Table / Table Options. Uncheck the enable drilldown button. Once you do this you will no longer be able to drill down "create sheets" until you re-check the button. If this is not what you want the only other option is to not save the workbook when you are done with it "looking at the data". Any changes you have made will not be saved including the new sheets you created. Hope this is a start. Thanks, Bill Horton "STILLA" wrote: (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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing extra Worksheets when drilling down in Pivots? | Excel Discussion (Misc queries) | |||
Preventing new worksheets from being created by PIVOTdrill downs | Excel Discussion (Misc queries) | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |