akkakm
Active Member
Hello EveryOne,
We have a problem importing grid data from xlsx file that containing a linked formula on an excel cell. The user get a web exception (exception occured in VTImportGrid.renderHTML4() java.lang.RuntimeException: Could not resolve external workbook name 'https://mycompany.sharepoint.com/si...G et XXX/Frais de gestion XXXX AG et XXX.xlsx'. The following workbook names are valid: ('')). This happened only on the new jde 9.2 TR 9.2.7.3, the same action in the old jde 9.0 TR 9.2.2.8.
I thought that may the system user can't access to sharepoint, so I asked the user to add it as admin with full right, I restart the HTML Services and re-test, I got the same error message.
Here is the steps:
1. Import Grid Data
2. Browse for file XLSX
3. Attach the XLSX file
4. After clicking on "OK", I get the exception error
N.B: I removed the company name only for security purposes
Thanks in advance for your help
We have a problem importing grid data from xlsx file that containing a linked formula on an excel cell. The user get a web exception (exception occured in VTImportGrid.renderHTML4() java.lang.RuntimeException: Could not resolve external workbook name 'https://mycompany.sharepoint.com/si...G et XXX/Frais de gestion XXXX AG et XXX.xlsx'. The following workbook names are valid: ('')). This happened only on the new jde 9.2 TR 9.2.7.3, the same action in the old jde 9.0 TR 9.2.2.8.
I thought that may the system user can't access to sharepoint, so I asked the user to add it as admin with full right, I restart the HTML Services and re-test, I got the same error message.
Here is the steps:
1. Import Grid Data
2. Browse for file XLSX
3. Attach the XLSX file
4. After clicking on "OK", I get the exception error
N.B: I removed the company name only for security purposes
Thanks in advance for your help