I think I just found the problem. All of the advice I received was correct,
the reason it didn't work for me at the time was because I had merge labels
check in the pivot table options. Once again thanks for all of the help
--
Thank You
Andrew Edmunds


"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