2007 Pivot formatting drops out when refreshed

[emilyjames]

I just converted from 2003 to 2007. When I refresh my pivots, the formatting drops out of the headers and they all turn black. Help!

 

[GlennUK]

Hi, can you describe what you did, exactly?

 

[Derek Brown]

Perhaps you could give some more information.
You say that you have 'converted' - do you mean that you converted the workbook from .xls to .xlsx (or .xlsm)?
Can you also confirm that the pivot tables were created in Excel 2003?
How were the headers formatted? (e.g. what method was used to achieve the formatting).
You could also look at the following podcasts for some ideas:
http://www.youtube.com/watch?v=besUhw_rBVA
http://www.youtube.com/watch?v=13tQaB3TgSs