Exporting a Reporting Services Report to Excel and Having the table header wrap

Question

I have a report in Reporting services, and when I preview it, the headers for a table wrap, but when I export it to Excel, the don't. They just get cut off. Any ideas on how to force it to wrap when I export to Excel?

Answer 1

Although this link doesn't address your question directly, its fairly comprehensive in terms of design considerations for Report Rendering in in Excel

Link: Designing for Microsoft Excel Output(Reporting Services)