SSRS Large Report -- Error When Exporting to Excel?

Question

We are having an issue when exporting a large SSRS report to Excel. We receive the following error when it is run over a three-year date range. If the report is run for each of the years separately, the error does not occur. > "We found a problem with some content in 'ReportName.xlsx'. Do you > want us to try to recover as much as we can? If you trust the source > of this workbook, click yes." After clicking yes, the file opens, but it doesn't look usable. What is the fix for this error, other than running the report for a year at time? I have changed the report's timeout to "Do not timeout report" in Report Manager, but that has no effect.

Answer 1

How large is your report? Excel's row length limit is just over a million rows for the newest versions of Excel.