Preserving pivot table formats. Preserve formatting checked but...

**judasdac** · 08-28-2009, 11:57 AM

Hi All,
I'm having a devil of a time trying to preserve the formatting on a pivot table that I made in Excel 2003. As near as I can tell, I've done the appropriate things --- check the preserve formatting box, uncheck autoformat --- but my formatting is not preserved when I pivot.

Adding to the mystery is the fact that some formatting is preserved but not all. I'm guessing either I'm missing something obvious or this is just an unruly, rogue pivot table that refuses to be formatted.

Any insight would be tremendously appreciated. I've attached the workbook.

Cheers,
Tim

**kindoflost** · 08-28-2009, 04:39 PM

I believe it is a bug.
See: support.microsoft.com/kb/886176
I had a similar problem with Pivot Chart Formatting.
Somebody suggested a fix in the registry, I think a macro to reformat is safer.