View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CG CG is offline
external usenet poster
 
Posts: 5
Default Sheet formatting after pivoting

I am having trouble with the format of my pivot table...

I drag a data element down into the table and it looks fine. When I
return that element to the top, the white fill color I have applied
to
all of the cells is gone and it then shows grid lines where the table
was. I just want a white background to remain no matter how I pivot.

I tried checking the "Preserve Formatting" in the table options, but
it doesn't seem to work.

Any suggestions?


thanks,
Chris