On Nov 17, 8:48*am, Nick Anderson
wrote:
Hi Jim

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

Nick



"Jim Thomlinson" wrote:
What type(s) of formats are you working with. Conditional Formats, borders
numeric, patterns...
--
HTH...

Jim Thomlinson

"Nick Anderson" wrote:

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- Hide quoted text -

- 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