The Make a Copy button of the Code Editor saves a separate copy of the script in your OneDrive. They are not copied to any of your local or OneDrive folders when you run the shared script in Excel. Scripts that are shared with one of your workbooks remain in the script creator's OneDrive. osts files, such as renaming or deleting files, will be reflected in the Code Editor and Script Gallery. osts files are found in the /Documents/Office Scripts/ folder. The default behavior is that Office Scripts are stored in your OneDrive. Whoever has access to the Excel file will also be able to view, run, or make a copy of the script.Įxcel only recognizes and runs a script if it's in your OneDrive folder, a Sharepoint folder, or shared with the workbook. This means you're linking the script with the file, not attaching it. To give users who are outside of the SharePoint site access to the script, share the script with an Excel workbook. They are stored separately from a workbook. osts files in your Microsoft OneDrive or a SharePoint folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |