We are having issue on our SSRS report as we are not able to Export the report output into Excel. We have around 4000 Page with 30 rows at every page (4000 *30 = 120000)
which is not able to export into excel 2007. If we have less records like 10000, we are able to export the report into excel.
SSRS 2008 and SSRS 2008 R2 export to excel 2003 format. When you export to excel, each page break will generate a new worksheet. So when you export 10000 rows excel file will have around 334 worksheets.