Formatting when doubleclicking in pivot tables

H

H. Rye

When I double-click in a pivot table, a new sheet is created, showing the
details behind the cell in the pivot table. However, the new sheet is
formattet automaticly, which causes a lot of problems. How can I controll
this auto formatting?
 
T

Tom Ogilvy

I don't believe you can. You would need to write event related code to
reformat the sheet.
 
Top