You have to apply your formatting to the fields in the pivot table rather
than the rows & columns in the worksheet. If you format a whole column that
includes part of your pivot table, for example, the formatting will be lost
when the pivot table is refreshed.

To format a field in the pivot table, put the cursor right over the heading
of the desired field, then slowly move the cursor upwards. Left-click when it
changes to a downward-pointing arrow. All the data for that field will be
selected. Now select Format Cells select your desired formatting OK.
Formatting applied this way will persist when the pivot table is refreshed
(such as when a new item is selected).

Hope this helps,

Hutch

"AndrewEdmunds" wrote:

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
--
Thank You
Andrew Edmunds