| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Pivot Tables | Excel Discussion (Misc queries) | |||
| Formatting pivot tables | Excel Discussion (Misc queries) | |||
| Need Help Formatting Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot tables - Formatting | Excel Discussion (Misc queries) | |||
| Pivot Tables and Formatting | Excel Worksheet Functions | |||
Linear Mode
