Formatting when doubleclicking in pivot tables
 

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?

Formatting when doubleclicking in pivot tables
 

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

--
Regards,
Tom Ogilvy

"H. Rye" wrote in message
...
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?