Automate

 View Only
  • 1.  CHAINING ISSUE - EXCEL IS EDIT MODE. CLICK ANY OTHER CELL

    Posted 05-06-2021 18:39
      |   view attached
    HI Winshuttle Gurus;

    I'm having an issue with a chained script.  The first part runs great, but when I get to the chained script it looks like it's running but then i get the pop dialog box, and when I close the excel sheet disappears.  When I try to re-open the excel sheet it tells me its being used, and to close and try to open again.  Only after completely shutting down my system does it finally let me into the script and the excel sheet.  Does anyone know why this is happening?  


    Thank you for any suggestions you offer
    Vicki Smith

    ------------------------------
    Vicki Smith | Procurement/Sourcing Advisor
    Southern California Edison (SCE) | 3109999284
    ------------------------------


  • 2.  RE: CHAINING ISSUE - EXCEL IS EDIT MODE. CLICK ANY OTHER CELL

    Employee
    Posted 05-07-2021 09:03
    Hi Vicki

    Chaining typically works well. 

    Can you share your chain settings?  Click on Chain - and if it's custom, click on the widget on the right and share a screen shot of your settings there.

    There are settings to designate if it's the same workbook, sheet, start row, etc.   Here is the doc page on this topic:  https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-foundation-user-gov/12/link-scripts.htm

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 3.  RE: CHAINING ISSUE - EXCEL IS EDIT MODE. CLICK ANY OTHER CELL

    Posted 05-07-2021 12:10
    Hi, I found out that you can't use one drive to store you files.  Even though i didn't have it automatically saved, it still caused a lot of issues.  Once i moved the files out of one drive, everything worked. 

    Thank you community for reaching out.

    ------------------------------
    Vicki Smith |
    | 3109999284
    ------------------------------



  • 4.  RE: CHAINING ISSUE - EXCEL IS EDIT MODE. CLICK ANY OTHER CELL

    Employee
    Posted 05-07-2021 12:29
    Happy it's working.   Thanks for letting us know, Vicki! 

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------