HI
When you drill down into detail on a pivot table it creats this data in a new sheet.
Is it possible to format the new sheet on opening.
As it creates a new sheet each time I cannot use on opening so cannot see how to do this ?
Or is there a way of making the drill down procedure open in a named sheet ?
When you drill down into detail on a pivot table it creats this data in a new sheet.
Is it possible to format the new sheet on opening.
As it creates a new sheet each time I cannot use on opening so cannot see how to do this ?
Or is there a way of making the drill down procedure open in a named sheet ?