Automate

 View Only

  • 1.  Anyone using MS Excel for Office 365 ProPlus?

    Posted 10-25-2019 00:25
    Hi Community,
    I was wondering if anyone else is using MS Excel for Office 365 ProPlus (Click- to-run) and having any issues?  Praying someone can help.   We are using Winshuttle Studio Version 12.1.0 with Foundation.    When we run scripts in Studio we click on "open a different file" (folder icon) and browse for the saved data template we want to run.  Once we click on Run, the excel file opens outside of studio  and the script begins to run. There is a message that the file is is read-only mode.  Once the run is complete, if we need to debug or run on errors we have to close the excel file first, then click on the retry button to open the file back up in Studio.   Does this happen for anyone else or are we doing something wrong?

    I have one user that is having an issue and I am stumped on how to solve it.  Every time the user runs a Transaction script in Studio he gets the following pop-up message:  "Please open the data file before continuing".    He cannot continue because the data file is already open outside of Studio and a second blank excel file opened at the same time.   He can, however, run the script in Excel using the Add-in with no issues.   It seems as though the problem is with his version of Excel and Studio.  

    I found that this user has a different version of Excel (1910) than the rest of us (1902).  I opened a ticket with Support, however the issue was not resolved.  The analyst sent my user an excel file to run. He was able to run the file that came from Winshuttle just fine in Studio, but he has not been able to run any excel files from our company.  I'm wondering now if maybe his version of Excel is not supported by Winshuttle.  Can any of the Solution Engineers weigh in?   I'm going bananas!

    Thanks,



    ------------------------------
    Monica Anicito | Master Data Analyst
    Ortho-Clinical Diagnostics, Inc., Raritan, NJ

    ------------------------------


  • 2.  RE: Anyone using MS Excel for Office 365 ProPlus?

    Employee
    Posted 11-18-2019 16:12
    Hi Monica

    We are running Office 365 Pro Plus.

    For the Runner activity, have they tried to open the template from the Excel add-in?

    1. Open Excel
    2. Go to the Winshuttle Run tab
    3. login to Winshuttle
    4. go to the Winshuttle Foundation tab
    5. click open - choose data template
    6. When they open it, they can save locally, fill with data and then try to run - as long as their is no data approval workflow.  if there is data approval workflow, they'll have to Submit to Foundation on the Foundation tab.  You'll know, because the Run button will be a Test button.


    Hope that gives you an idea.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    pse | Winshuttle North America
    ------------------------------

    Original Message


  • 3.  RE: Anyone using MS Excel for Office 365 ProPlus?

    Posted 11-18-2019 17:13
    Hi Monica,

    I'm sorry the first support ticket that was opened caused some frustration. I was able to work with you in your re-opened ticket where we found the workaround listed below. There seemed to be a code conflict with 12.1 and syncing to OneDrive that did not exist in 12.0.

    1. Right-click on the OneDrive icon and go to settings.
    2. Go to the Office tab .
    3. Uncheck the option "Use Office applications to sync Office files..."
    4. Click Ok.

    We have created an Enhancement request on our Development team side to get syncing with OneDrive working again in future releases. Thank you for bringing this to our attention, as well as your patience while we worked to get this resolved.

    Thank you!
    -Shelby

    ------------------------------
    Winshuttle Support |
    Winshuttle North America |
    ------------------------------

    Original Message