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!!

I understand how frustrating it can be when the font size in a pivot table changes upon refresh. Here are some steps you can try to fix this issue:

1. Select the entire pivot table by clicking on the top left corner of the table (where the row and column headers intersect).
2. Right-click on the selected area and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, select the "Font" tab.
4. Set the font size to 12 and click "OK" to close the dialog box.
5. Refresh the pivot table and see if the font size stays at 12.

If the above steps don't work, you can try the following:

1. Select the entire pivot table again.
2. Right-click on the selected area and choose "Table Options" from the context menu.
3. In the Table Options dialog box, uncheck the "AutoFormat Table" option.
4. Click "OK" to close the dialog box.
5. Refresh the pivot table and see if the font size stays at 12.

If neither of these solutions work, you can try creating a new pivot table and formatting it with the desired font size before adding any data to it. This should ensure that the font size stays consistent upon refresh.

I hope these steps help you resolve the font size issue in your pivot table. Let me know if you have any other questions or concerns.

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