Automate

 View Only
  • 1.  Winshuttle error, data file is protected by a password?

    Posted 04-25-2024 04:32

    I have faced an error which happens consistently (30% of the time), when I try to run a script. The data file (excel) doesn't have any password protected.

    I have tried:

    -Changing network connection

    -Different scripts

    -Different location of the script and data file

    -New script creation

    Please advise.

    Error:



    ------------------------------
    Best Regards,
    Nart
    ------------------------------


  • 2.  RE: Winshuttle error, data file is protected by a password?

    Employee
    Posted 04-25-2024 08:30

    Hi Nat

    Could it be the file is on OneDrive or SharePoint?  If so, here is a support artcle: https://customer.precisely.com/s/article/Data-file-issues-on-OneDrive-or-a-network-Drive-360040400411?language=en_US

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Winshuttle error, data file is protected by a password?

    Posted 04-26-2024 00:46

    Yes it is.

    The excel format wasn't xls in the first place, it was either xlsx or xlsm. So, the solution of changing excel format doesn't apply here.

    Is there more solution to this?



    ------------------------------
    Best Regards,
    Nart
    ------------------------------



  • 4.  RE: Winshuttle error, data file is protected by a password?

    Posted 04-26-2024 11:36

    I have seen these errors when the template file has been run against one system and you try to run it against a different system.

    Open the Excel file up, look for Hidden Tabs, you will probably see a Winshuttle tab, delete that tab and try running it. 

    I have also had success after the file is open in Studio, when on the Run tab, clicking on the Excel icon to open the file, save it and reload it in Studio.



    ------------------------------
    Josh Bawden
    Information Management Engineer
    J.R. Simplot Company
    ID
    ------------------------------