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