A call to Microsoft.Dynamics.Nav. OpenXml.Spreadsheet.WorkbookReader.Open failed

Business Central/NAV Developers Forum
1

Hello All,

I wanted to import excel file, but…

I am facing “A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: foldername…” while opening the excel by using “Excel Buffer” in Function “SelectSheetsName” in “XlWrkBkReader.Open(FileName);”.

when I was tried it on App server it’s working fine, but when end user tried then system show’s above error.

“Windows Event Viewer” is also not any information.

Thanks!

2

Is it a “home made” customization or when using the standard functionality?

If it works on the server, then my guess that the code doesn’t read the file from the client files, but from the server.

Which version of NAV is this???

3

Hello Erik,
Thanks for reply.

Code is std. from Excel buffer table.

we have using NAV 2016.

Can you tell me other possibilities to resolve this issue?

4

It could be that the user have the file open (locked) when trying to import it.