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

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

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

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

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