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


Background:
We recently moved from SQL 2005 to SQL 2012.  This means reporting services also as it was on the same box.  

Issue:
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.

Reporting Services issue when exporting to Excel

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.