Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Excel Export not worki...

Excel Export not working correctly in NAV 2018

(0) Share

Report

Posted on by Community Member Microsoft Employee

We are using NAV 2018 W1 11.0.23019.0 and experience that the Excel Export is not correct in every case. Sometimes the numbers from field are just copied in the following rows if the value of these fields is 0, sometime it works correct. In addition, sometimes the <Limit Totals To> filter will be ignored in the Excel Export.

What can be the reason for this behaviour?

Thanks and best regards

Michael

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Excel Export not working correctly in NAV 2018

Is there any update on this issue?

My customer (NAV 2018 CU5) are also experiencing that Excel export automatically fills empty cells with value from previous row.

But only on one computer with Office 365 installed get the issue when using the "Send to Excel" function.

If the user manually copy/paste the lines to Excel, there is no issue.

Other computers with older Office versions do not have this issue.

My own computer with Office 365 does not have this issue.

(Running the same ClickOnce package as my customer, on my computer with Office 365 works just fine!)

Reginal settings is ok and office is fully updated.

Found some articles that describes the same issues, but with no replies.

Regards

Tom Erik