Posted 4 August 2017, 2:37 pm EST
Large files generate the following error on export:
Description: ActiveReports Excel Export Error:Internal Error. Pages collection or RDF file may be corrupt.
Exports on a smaller range or the use of RDF/PDF work fine. The source of the problem is that the report length is exceeding the maximum length allowed by an Excel spreadsheet. The historical report in question returns a 1711 page report.
Each page of the report contains between 50 and 60 rows of data.
1711 pages x 50 rows = 85,550 rows
Excel’s row limit on a worksheet is 65,539 < http://support.microsoft.com/default.aspx?scid=kb;en-us;264626>
Is there a way for you guys to alter the Excel Export to switch to a second worksheet within the spreadsheet to avoid this issue?