Pivot Table Formatting

  • Thread starter Thread starter Nick Anderson
  • Start date Start date
N

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
 
What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...
 
Hi Jim

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

Nick
 
Hi Jim

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

Nick







- Show quoted text -
Click to expand...

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