LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Preventing extra Worksheets when drilling down in Pivots? STILLA Excel Discussion (Misc queries) 1 November 15th 05 12:28 AM
Preventing new worksheets from being created by PIVOTdrill downs STILLA Excel Discussion (Misc queries) 0 November 10th 05 06:05 AM
Duplicate Worksheets mlofton Excel Discussion (Misc queries) 1 September 7th 05 02:58 PM
Changing a Link Mid-way Across Worksheets Frosty Excel Worksheet Functions 0 August 25th 05 12:03 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"