Reporting Services issue when exporting to Excel
Posted on 2015-01-22
We recently moved from SQL 2005 to SQL 2012. This means reporting services also as it was on the same box.
Some reports when you export to excel are getting a strange message when opening them. “Excel found unreadable content in “Active Price Page.xlsx”. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
If you click yes it does remove some columns so the end use can no longer trust the report. Like I said before the reports having this issue didn’t have any issues before the move to SQL 2012.
What I’ve tried:
I thought I may need to redeploy the report after converting it to the newer version of Visual Studio but it didn’t work.
Remove any special formatting in the report but that didn’t help either.
We then exported to CVS which works but isn’t a solution we want to use permanently.