| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Tables: need to customize formatting
Hello:
I have several PivotTables. I do not want to use the prepackaged MSoft formatting: color, fonts all that. Everytime I change the formatting and the table is subsequently refreshed for new data, the formatting is destroyed. How do I hold my formatting changes fixed? Is there a way around this goofy thing? Thanks, pepenacho |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Tables: need to customize formatting
mouse right-click in pivot table. untick autoformat table -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=526103 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Tables: need to customize formatting
Thanks
"steven1001" wrote: mouse right-click in pivot table. untick autoformat table -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=526103 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Tables: need to customize formatting
Steven,
That does not work. Although it takes away the preset formatting it just then proceeds to put everything in a bar-type table. It's just ughly and aweful. Is there a way to complete shut that down?? The goal is: once I set a format, it needs to stay stable? Is there a way? Thanks, pepe "steven1001" wrote: mouse right-click in pivot table. untick autoformat table -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=526103 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivot Tables: need to customize formatting
Ok, I got a part of what you're talking about to work. But the labels for the
column information (basically the fields) the formats keep getting destroyed after a refresh.... "steven1001" wrote: mouse right-click in pivot table. untick autoformat table -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=526103 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two Pivot Tables One pivot chart | Excel Discussion (Misc queries) | |||
| Pivot tables - inserting columns | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Linear Mode
