Reporting Services issue when exporting to Excel

Posted on 2015-01-22
Medium Priority
Last Modified: 2015-01-26
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.
Question by:abarefoot
1 Comment

Accepted Solution

abarefoot earned 0 total points
ID: 40571160
I solved this myself.  The issue was with the new version of Excel not playing nice with the report.  To fix this I simply gave the users an option to save the file in the older xls Excel format.  

You have to edit the reporting services config file.
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

Then add '2003' so users can know the correct one to select and change false to true so it will show up as an option for the users.  See  below.

<Extension Name="EXCEL2003" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Viewers will learn the different options available in the Backstage view in Excel 2013.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question