Export to Excel fails if there are more than 32,000 rows when exporting to XLS or with hundreds of rows when exporting to XLSX, and one of the columns is of type currency.

Steps to Reproduce

  1. Navigate to a list containing more than 32000 rows.
  2. Ensure that a Currency field is in the list.
  3. Right click on the header and select Export > Excel (.xlsx).
    The export fails.


If exporting more than 32000 records to XLS there are two possible workarounds:

  • Reduce the number of rows to export
  • Export to CSV and then convert to Excel

If exporting fewer than 32000 records to XSLX in Helsinki, export to XLS instead. To use XLS export, set the system property glide.legacy.excel.export to true.

In UI16, additional steps are required to make the UI Context for XLS appear in the list:

  1. Navigate to System UI > UI Context Menus.
  2. Open the Excel (.xlsx) record.
  3. Clear the Active check box.

Note: If you are using List v3, XLS export cannot be enabled. Instead, export to CSV.

Related Problem: PRB674142

Seen In

Geneva Patch 3
Geneva Patch 3 Hot Fix 9
Geneva Patch 4
Geneva Patch 6
Geneva Patch 6 Hot Fix 2
Geneva Patch 7
Geneva Patch 7 Hot Fix 5
Geneva Patch 9
Helsinki Patch 0 Hot Fix 1
Helsinki Patch 1
Helsinki Patch 1 Hot Fix 1
Helsinki Patch 2
Helsinki Patch 3
Helsinki Patch 3 Hot Fix 2
Helsinki Patch 3 Hot Fix 7
Helsinki Patch 4
Helsinki Patch 5

Fixed In

Geneva Patch 10
Helsinki Patch 7

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:32:28