if you want to format the pivot table and keep it from reformating when you refresh,it is pretty simple once you know its there.

Right click on the pivot table
Got to Pivot Table Options
Uncheck
Autofit Column Widths on update
AND
Preserve Cell Formatting on update

this should shut down excels default re-formatting