Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
How can I sum a cell in multiple worksheets as new ones are created. | Excel Worksheet Functions |