E1: GRID: Unable to Export to Excel with More Than 65536 Rows on Excel 2007 or Higher (Doc ID 1248034.1)

Last updated on AUGUST 01, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Symptoms

I am using the Excel 2007 version and according to <Document 662069.1>, Excel 2007 can have a maximum Worksheet size of 1,048,576 rows by 16,384 columns. However, I am unable to export more than 65,536 rows of data to Excel.

When trying to export grid data to Excel, Excel does not load. When trying to submit a UBE with Export to CSV option selected, and when Excel tries to open the output, the error "File not loaded completely" is shown in Excel:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms