Search code examples
excelreporting-services

Reporting Services export to Excel causes 'Repair' and removes styles

I have quite a complex SSRS report that I would like to export to Excel more or less how it looks in the web output.

Export to Excel and opening in Excel 2010 yields the following error:

Excel was able to open the file by repairing or removing the unreadable content. Removed part: /xl/styles.xml part (Styles)

All the styling is gone from the report, so it looks terrible.

Solution

  • After isolation testing it I have fixed 99% of the style errors by one simple change:

    Excel doesn't seem to like 'Total' cells for Row Groups within tables having no Font='' (these cells are auto-created when you create a total for a group)

    Font=", 10pt, Default, Bold, Default"

    Change Font to "Arial":

    Font="Arial, 10pt, Default, Bold, Default"