Export of more than 32000 records to Excel results in creation of more than one worksheet



  • When exporting from list view in Excel format, all records are not seen in one worksheet.
  • Another symptom might be that all records are not seen in the export - whether downloaded or emailed, when export is in Excel format


Applicable for all releases


This is a property of Microsoft excel, due to which there are no more than 32000 records exported in one spreadsheet. If there are more records, they might be on other sheets.


If missing records are reported, then other sheets in the exported Excel file should be checked. The total of all the records would match the records in the report in List view.