SBX - Search With Button

SBX - Forum Post Title

Nav 2016 Issue with Excel

Microsoft Dynamics NAV Forum

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

Question Status

Verified

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

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
Andrey Baludin responded on 17 Apr 2018 2:45 AM
My Badges
Suggested Answer

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

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

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

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

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

Reply
Suggested Answer

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
Andrey Baludin responded on 17 Apr 2018 2:45 AM
My Badges
Suggested Answer

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

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

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

Reply

SBX - Two Col Forum

SBX - Migrated JS