As far as I know, you can't avoid it. Record a macro when formatting,
and play it after each update.
Regards.
Daniel

In my pivot table, whenever I select a new item through the drop down box of
my field my formatting gets screwed up. I have unchecked auto format table
and I have checked preserve formatting.

For example, I have a balance sheet and I use the drop down box to select
different facilities in order to see their balance sheet values. Whenever I
select a different facility, all of the row headings go from being left
justified to centered and bottom justified to centered.

I appreciate any advice you could give