Formatting Pivot Table Titles

Meredith

New Member
Joined
Oct 2, 2006
Messages
26
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

mrhartley

Well-known Member
Joined
Mar 8, 2005
Messages
564
Hi,

You could try taking the auto format tick out.

See if that helps.

~Mark
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,727
Members
410,630
Latest member
JFORTH97
Top