Drill down to new window instead of worksheet

[kyle.breen]

Hi folks,


I've been working on putting our old sales file into a pivot table form

and the results look pretty good. My only concern is drilling down in
the pivot table. I would prefer to be able to drill down to a new
excel window instead of a new worksheet. The reason for this is the
people that will primarily use the pivot table may not delete the
drilldown worksheets and the workbook could turn into a bloated mess
before very long. Any help would be appreciated!



Thanks,


Kyle

 

[Debra Dalgleish]

You can't change the settings for the drill to details feature. Maybe
you could create a template file for them to use, so they don't save
over the original copy.

 

[kyle.breen]

Thanks Debra. I'll try what you suggested.