Drill down to new window instead of worksheet

[[email protected]]

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.

[email protected] wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[[email protected]]

Thanks Debra. I'll try what you suggested.