NAV crushes while exporting to Excel

snyktp
snyktp Member Posts: 75
Hi All,

We didn't have this issue before but suddenly we started to have it (maybe because of windows update ? ), we are not sure what the problem is.

Version - Dynamics NAV 2017
Problem - Exporting to Excel by using Ctrl+E . If we try to export from any list page (customer list, item list , assembly bom list, etc), it works without any issue. However, if we try Ctrl+E with Card & Document pages (sales order, purchase order etc) ,NAV crushes and closes.

Do you have any idea what the issue/solution is ?

Thank you

Answers

  • sorenhinrup
    sorenhinrup Member Posts: 136
    Do you have anything in the event viewer?
  • snyktp
    snyktp Member Posts: 75
    Application: Microsoft.Dynamics.Nav.Client.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.IO.FileLoadException
    at Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.OpenExcelUsingCom(System.String, Boolean)
    at Microsoft.Dynamics.Nav.Client.WinClientExcelExportService.StartShowingExcelFile(System.Object)
    at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(System.Object)
    at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
    at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
    at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
    at System.Threading.ThreadPoolWorkQueue.Dispatch()
    at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
  • edoderoo
    edoderoo Member Posts: 89
    All I can tell you: here it works on NAV2017 10.0.18197.0 for a customer card.
    Do you get the same error on every card, or only on the customer card? Did you also try on other workstations?
    IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;
  • snyktp
    snyktp Member Posts: 75
    We don't have any issue on the card pages., we have that issue on the document pages like sales order, posted sales invoice, purchase order etc

    Thanks