Nav 2016 Issue with Excel

(0) Share

Report

Posted on by dmourghen

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.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

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

Was this reply helpful? Yes No
dmourghen 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
dmourghen 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
dmourghen 10 on at

Like (0)

Report

Here is the error.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
dmourghen 10 on at

Like (0)

Report

your right it was a permission issue

Was this reply helpful? Yes No