Unable to export reports from Report Viewer to Excel if report is bigger than 65,536 rows
Excel places limitations on exported reports due to the BIFF's format capabilities. The most significant are the following:
- The maximum number of rows in a worksheet is limited to 65,536. If this is exceeded, the renderer displays an error message.
Work with lower number of objects so report is less than 65k rows.