E1: GRID: Export to Excel 2007 Fails with Error "Problems came up in the following areas during load"
Last updated on NOVEMBER 01, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
When exporting grid data rows to Microsoft Excel 2007, we receive the following pop-up error:
This file cannot be opened because of errors. Errors are listed in :
C:\Users\Gerry\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\557C8A0C.log"
Steps to Duplicate :
- From P4210 Sales Order Details Revisions, from Tools Select Export Grid Data
- Click Continue
- Select Open with Microsoft Office Excel and click OK button
- Excel opens but pop up a screen saying "The file you are trying to open, 'export.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
- If you click OK, you will get the above error message.
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