Pivot Table Formatting

[Nick Anderson]

I have a pivot table that I am trying to keep the formatting on. Everytime I
pivot the table, the formatting that I have set disappears. I have been
online and have read numerous ideas on how to get this to work but none seem
to work the way I need them to.

I have the auto format option and the perserve formatting boxes checked.
Does anyone have any ideas on how to keep the formatting?

Your help is appreaciated,

Thanks
Nick

 

[Sean Timmons]

You want autoformat UNchecked.

 

[Jim Thomlinson]

What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...

 

[Nick Anderson]

Hi Jim

I am working with column widths. That seems to be the big thing that changes
when I refresh.

Nick

 

[Ryan]

Hi Jim

I am working with column widths. That seems to be the big thing that changes
when I refresh.

Nick







- Show quoted text -

I ran into a similar problem with my reports. The only solution that I
could find was to create a macro while I set up my formats. Then run
it each time I refresh.

Ryan