How to change Export To Excel2016 from ExportToExcel2003 in SSRS

Question

Currently using SSRS 2016 but for some reason don't see the option to save the report in Excel 2016 and instead get the option of saving in Excel 2003 and Word 2003. How do I change it to Excel 2016?

Answer 1

Hi @Irfan ,

The Excel rendering extension renders a paginated report to the Microsoft Excel format (.xlsx). With the Excel rendering extension.

The format is Office Open XML. The content type of files generated by this renderer is application/vnd.openxmlformats-officedocument.spreadsheetml.sheet and the file extension is .xlsx.

Displayed as "Excel" in the export menus when reviewing reports. The Excel rendering extension renders a report as an Excel document (.xlsx) that is compatible with Microsoft Excel 2013.

The Microsoft Excel 2003 rendering extension is deprecated.

If you want to disable Excel 2003 with your current office version (2016), you need to modify the RsReportServer.config Configuration File in the following path: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer.

Modify as follows:

<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>  
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>  

The EXCELOPENXML extension defines the Excel renderer for current (.xlsx) Excel files. The EXCEL extension defines the Excel 2003 version. Visible = "false" indicates the Excel 2003 renderer is hidden.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.