View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LordCommando LordCommando is offline
external usenet poster
 
Posts: 2
Default Formatting lost in a Pivot Table after a data refresh

I designed a Pivot table to look at various data, with 2 fields in the
column section. The information is perfectly accurate, but because of
the quantity of information, I have to set a specific alignment for
readability for the 2 fields. If I add information and refresh, I'm
loosing a portion of my formating. What should I do?

Take a look at these 2 images for a better idea of the problem:

http://i141.photobucket.com/albums/r...xcelbefore.jpg
first image, look at line 4, properly aligned.

second image after refresh, line 4 is not the same anymore. sniff :(
http://i141.photobucket.com/albums/r...Excelafter.jpg
Any help will be welcomed.

Lord Commando Of the Styx