View Single Post
  #2  
Old November 17th, 2009, 05:24 AM posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
 
Posts: 1,722
Default 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