View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cash
 
Posts: n/a
Default Maintain Format of Pivot Table

I have a Pivot Table, when I refresh the table a certain column changes it
format so that the alignment of the data is no longer centered (i.e. some
data is aligned left, some aligned right, etc). I have 'Preserve Format'
clicked. Also, in the data table that feeds the pivot table the specific data
is 'aligned center'....

Any ideas how I can maintain a format?

Cash