When refreshed, some Pivot Table columns retain formatting, some d
 

I have not had trouble with retaining column widths and column heading
formats (font size, word wrap, alignment) in Pivot Tabl. When refreshed,
they retain formatting.

Here's the weird part, when I add or insert a new data column into the Pivot
Table by checking from field list, that new data column does not retain
column heading formats (font size, word wrap and alignment settign) like the
original columns do. It does however preserver its column width and number
formatting. Why is that?

How do I tell Excel to preserve column heading formats for newly added ones?

I am using Office 2007