Why do I get only 16,363 rows when I export to Excel?

Download PDF version of this faq: ExcelRowLimit.pdf

Issue: The Crystal Reports Excel export DLL (ie. U2fxls.dll) has a MAXIMUM record limit, which is to export to a MAXIMUM of 16,384 rows.

NOTE: This is the row limitation of Microsoft Excel 4.0, 5.0, and 7.0 (and not of Crystal Reports).

Solution: The row limitation in Microsoft Excel 8.0 is now 64,000. Only the Crystal Reports version 7 export DLL for Microsoft Excel can export up to this maximum limit.

For more information on this issue, please refer to Crystal Decision Knowledge base document number 2000454: http://support.crystaldecisions.com/kbase/c2000454.asp