Symptoms

• 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

Release

Applicable for all releases

Cause

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.

Resolution

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.