Unable to export reports from Report Viewer to Excel if report is bigger than 65,536 rows
From http://msdn.microsoft.com/en-us/library/ms159836.aspx
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy