web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Excel Export not working correctly in NAV 2018

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans