Sage 100

 View Only

  • 1.  Unable to export to Excel (application) - need to go to file first

    Posted 10-15-2019 13:11
    Sage 100 2019 Advanced - SU1.

    If you preview a report and export it to excel, if you choose Excel Workbook data only, and application, it will not export to the excel application and the window just closes down with no error.  It works if you send it to a file, and the 97-2003 options can export to the excel application and to a file.

    Has anyone seen this ?

    Version of excel below:





    Thanks in advance

    Jeff


    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------


  • 2.  RE: Unable to export to Excel (application) - need to go to file first

    Posted 10-15-2019 13:20
    Is it Win 10 build 1809 or 1903?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 3.  RE: Unable to export to Excel (application) - need to go to file first

    Posted 10-15-2019 13:26

    1809

     



    ------Original Message------

    Is it Win 10 build 1809 or 1903?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 4.  RE: Unable to export to Excel (application) - need to go to file first

    Posted 10-15-2019 13:42
    As a test, attach an .xlsx file to a customer memo and save the memo and close out of the customer.  Then, open the memo again in customer maintenance and try and double click or use the button in the right margin to open the file.  See if you get the same behavior of the screen closing unexpectedly. 

    The below information may serve as a workaround:

    As a temporary workaround rename ..\MAS90\Home\xmllite.dll to \MAS90\Home\xmllite.old

    *Caveat*  If the customer has development partner modifications that include the interpreter utilizing XML functionality renaming the file above will cause an error in the development partner functionality."



    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 5.  RE: Unable to export to Excel (application) - need to go to file first

    Posted 10-15-2019 13:43
    You will have to do the rename workaround on both the server and the workstation.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


Related Content