Pivot Table Formatting
 

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

Pivot Table Formatting
 

You want autoformat UNchecked.

"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

Pivot Table Formatting
 

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

Pivot Table Formatting
 

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

Pivot Table Formatting
 

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