Pivot Table Drill Down

[christipper]

Morning,

When drilling down in a piovot table by douible clicking to see the detail behind the total a new sheet opens. Is there anyway to get this to open in a new window? This will save the user of the file having to delete several tabs after they have finished analysing the data.

Cheers

Chris

 

[m.k.johnson86]

Try this

http://www.ozgrid.com/forum/showthread.php?t=68798