Formatting Pivot Table Titles

[Meredith]

I am using a pivot table as my report, and whenever I refresh, the Formatting I have done to the Headings reverts back to the original format.

I have tried clicking and unclicking the "preserve formatting" option in table options but this doesn't seem to help.

The only thing I can find online is the followign add-in. Would this work? is there anyway around using an add-in?

http://office.microsoft.com/en-us/marketplace/EM011747601033.aspx

 

[mrhartley]

Hi,

You could try taking the auto format tick out.

See if that helps.

~Mark