Hi,
We have an SSRS report which exports more than 65K data to excel file. The report fails midway due to excel(1997-2003) restriction of 65K rows. Is there an option to export the SSRS report to excel 2007 format.
Any help, will be greatly appreciated.
Error:
Exception in Task: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536. ---> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536.
Thank you.