This is a really annoying problem that shouldn't be this hard. I have
a pivot table in which I want the font size to be 12. However, when I
refresh the table or do anything to it the font size changes back to
ten. Not all the cells change, which makes the report look strange
with some cells having font size 12 and some ten.

Things I have done:
I have the preserve formatting option checked and the autoformatting
option unchecked.
I had a similar problem...I wanted certain cells to be shaded
different colors. Upon refresh, some would be shaded and some would
revert back to no color. To fix it, I set up a conditional format
that would shade the cells as long as they had data in them. Which
works, since they all have some type of data. However, this won't
work with the font size since conditional formatting won't let you
change this.
I'm using Excel 2003 with windows XP

Please Help!!