Ok, I think I fixed it. Anybody else that has this problem do the
following.

Click Format, Style

and change the 'Normal' style to what you want, and then click apply.
It worked for me...hope it works for other people. If anybody else
knows another way to fix this please post...or to describe the use of
styles. I never used them before.



Jake wrote:
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!!

Format changes changed refresh pivot table report