Automate

 View Only
  • 1.  How to remove embedded scripts in an data file Excel partially

    Posted 02-06-2024 10:53

    Hello,

    I have to update some scripts and then update all Excel templates that use them.

    In order to remove embedded scripts, we can unhide sheets and we see "WinshuttleStudio". If we remove this sheet, all embedded scripts are deleted in the Excel. But how do we just remove one or two scripts and leave the rest? The content in this sheet does not show names or similar to identify them.

    Thanks.



    ------------------------------
    Fernando Martin
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: How to remove embedded scripts in an data file Excel partially

    Posted 02-07-2024 08:48

    Hello,

    For me, in the Studio tab of Excel in the Files section of the Ribbon the top field for me has the scripts, if you click on the down arrow it shows all the embedded scripts in the Excel file. If you select the script entry you want to delete and then click the dropdown next to "Information" and select Remove. Do this for each script you want to remove from the excel file. Then save the Excel file and the scripts will be removed. As per screen shots:



    ------------------------------
    Martin Axon
    Master Data Specialist
    Thermo Fisher Scientific (UK)
    ------------------------------



  • 3.  RE: How to remove embedded scripts in an data file Excel partially

    Posted 02-07-2024 09:56

    Many thanks Martin for the detailed explanation. This solution works. Regards.



    ------------------------------
    Fernando Martin
    Knowledge Community Shared Account
    ------------------------------



  • 4.  RE: How to remove embedded scripts in an data file Excel partially

    Employee
    Posted 02-07-2024 10:55

    Hi Fernando

    Martin's suggestion works.  You can also request a Studio utility via a support ticket, which will let you open a template and edit some of the settings for scripts, including deleting them.

    There are some other features, as well:

    Hope this is helpful,

    Sigrid



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



  • 5.  RE: How to remove embedded scripts in an data file Excel partially

    Posted 02-08-2024 08:59

    Hello Martin and Sigrid,

    many thanks for your input. Now I am able to delete individual embedded scripts from a file.

    Another question. Once you remove one, if you publish again it will be added always at the end of the dropdown list? For example, the script in position 2 is removed, but then published again with the changes. Is there a way it appears again in the same position than before or it is always at the end?

    Regards,

    Fernando



    ------------------------------
    Fernando Martin
    Knowledge Community Shared Account
    ------------------------------



  • 6.  RE: How to remove embedded scripts in an data file Excel partially

    Employee
    Posted 02-08-2024 09:26

    Hi Fernando,

    If you publish again, it will show up at the end.  The utility will allow you to reorder them.

    Best Regards,

    Sigrid



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