Nav 2016 Issue with Excel

Question Status

Verified
dmourghen asked a question on 16 Apr 2018 10:45 PM

Hello,

We are trying to import and  excel file onto NAv 2016 and this is the error I have.  We have even tried to repair and install back the SDK but yet it does no work.

Message below i get

"a call to microsoft.dynamics.nav.openxml.spreadsheet.workbookreader open failed with this message"

any idea what can cause the issue.

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 12:58 AM

Is this a custom import via Excel (custom code) or what? It seems that the code is not able to open the Excel Book. The problem could be file not found, incorrect name or format. Can we have more details regarding the function you’re using and the message?

Reply
Suggested Answer
Andrey Baludin responded on 17 Apr 2018 2:45 AM

If it's a standard importer it could be :

1. Excel not installed on server/client

2. You try to import file from web client

Reply
dmourghen responded on 17 Apr 2018 4:19 AM

We tried to access the file from a shared folder and it works fine but when we do it from our local dynamics NAV application it gives this error

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 4:34 AM

Can we have the error in details? What's the exact message? It could be also a problem related to permission for the NAV user in order to access the folder where you have the Excel file, but without seeing the error in details it's quite difficult.

Reply
dmourghen responded on 17 Apr 2018 4:38 AM

how to attach the screenshot here or can you share an email id for me to send u

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 4:47 AM

Reply to this post, click on "User rich formatting" and upload the screenshot (there's a button for that).

Reply
dmourghen responded on 17 Apr 2018 4:50 AM

Here is the error.

Reply
Verified Answer
Stefano Demiliani responded on 17 Apr 2018 5:26 AM

Ok, this is a permission problem. \\10.2.1.96 is your machine?

Reply
dmourghen responded on 17 Apr 2018 5:30 AM

your right it was a permission issue

Reply
Verified Answer
Stefano Demiliani responded on 17 Apr 2018 5:26 AM

Ok, this is a permission problem. \\10.2.1.96 is your machine?

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 12:58 AM

Is this a custom import via Excel (custom code) or what? It seems that the code is not able to open the Excel Book. The problem could be file not found, incorrect name or format. Can we have more details regarding the function you’re using and the message?

Reply
Suggested Answer
Andrey Baludin responded on 17 Apr 2018 2:45 AM

If it's a standard importer it could be :

1. Excel not installed on server/client

2. You try to import file from web client

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 4:34 AM

Can we have the error in details? What's the exact message? It could be also a problem related to permission for the NAV user in order to access the folder where you have the Excel file, but without seeing the error in details it's quite difficult.

Reply
Suggested Answer
Stefano Demiliani responded on 17 Apr 2018 4:47 AM

Reply to this post, click on "User rich formatting" and upload the screenshot (there's a button for that).

Reply