[SOLVED] 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

mouse right-click in pivot table.
untick autoformat table

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
>
>

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
>
>

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
>
>