Automate

 View Only

  • 1.  Error Occurred While Opening Excel - new error

    Posted 08-08-2024 06:30
    Edited by Lee Hassett 08-08-2024 06:33

    HI

    Since 9th / 10th July 2024 we have had a problem running Winshuttle where a Query wants to work in Background Mode. The query runs but when entering the "Writing Data" stage we get a pop up Windows message as below "Error Occurred While Opening Excel".

    If we remove the Background flag, the query runs ok. But this cannot be done with all queries where there is a level of complexity and Background mode is compulsory.

    We have tried new excel workbooks and queries. Also re-installed Winshuttle and it worked ok until restarting the laptop.

    This same query has been used many times in the last 12months

    Any ideas or experience appreciated

    (Winshuttle studio 20.3)

    Thx

    lee



    ------------------------------
    Lee Hassett
    Senior SAP Business Support Analyst
    Innospec Ltd
    ------------------------------



  • 2.  RE: Error Occurred While Opening Excel - new error

    Posted 08-08-2024 07:34
      |   view attached

    Hi Lee,

    We experienced the same with Microsoft 365 excel version 2405 (Build 17628.20110)

    I am now on version 2406 (Build 17726.20160) and able to run Query in background mode again.

    (Winshuttle studio 20.3)



    ------------------------------
    Renette Nienaber
    Data Management specialist
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------

    Original Message


  • 3.  RE: Error Occurred While Opening Excel - new error

    Posted 09-02-2024 10:59

    Hi,

    I'm experiencing the same issue, but already have version 2406 from Excel. Anyone with an idea/solution on how to solve this?

    Thanks!

    Petra van Houwelingen

    Business Data Analyst
    AkzoNobel 



    ------------------------------
    Petra Vanhouwelingen
    Akzo Nobel Coatings
    Louisville KY
    ------------------------------

    Original Message


  • 4.  RE: Error Occurred While Opening Excel - new error

    Posted 09-16-2024 04:48

    Hi Winshuttle support fixed this for us by adjusting a .dll file. It was a genuine issue it seems with compatibility between MIcrosoft and WS



    ------------------------------
    Lee Hassett
    Senior SAP Business Support Analyst
    Innospec Ltd
    ------------------------------

    Original Message


  • 5.  RE: Error Occurred While Opening Excel - new error

    Posted 18 days ago

    Hi Lee,

    Can you please share the solution provided by the support ? do you know which DLL file was updated and how?

    I am having the same error and wanted to see if it can be fixed by updating the DLL file.

    Thanks

    Ocal



    ------------------------------
    Ocal Yilmaz
    SAP MDM, Winshuttle consultant
    e.l.f. Cosmetics, Inc.
    Oakland TX
    ------------------------------

    Original Message