Formatting in excel goes crazy. version 2008 (R2) only RRS feed

  • Question

  • Problem:

    - After exporting the report to excel, right-click on the tab and choose "Move or copy..." and move the sheet to another workbook. You will see that the colors or changed. I noticed that if you select a range, then copy and past special > format you have the same result.

    I first thought that this was the result of the background properties specified in my cube, but these colors are correct, trying this on a report based on a relational DB, without BG-Color gave me the same result. So it must be Reporting Services or Excel :-).


    Note that this is only in SSRS 2008 R2, it is a migration of SQL 2005 with same data, same reports, same cube and there we don't this "issue".


    A lot of end-users utilize this application so any help/suggestions are welcome!


    Thanks in advance!


    Friday, August 12, 2011 6:58 AM