Microsoft 365 Apps, OneDrive for Business, Office for the web, Microsoft 365 Experts
From Microsoft Corporation
Technical Bulletin MC394517 · Published Jun 21, 2022
Action required by Jul 29, 2022
Office Scripts is an automation feature set in Excel for the web. With this update, users can save their scripts to a SharePoint site, in addition to their OneDrive for Business.
Note: External network calls made within a script that is saved to a SharePoint site are not supported at this time. If any SharePoint-based scripts do contain an external call, the script will return an error when ran and the external call will not be made.
This message is associated with Microsoft 365 Roadmap ID 93767
When this will happen:
This change will begin rolling out in late July and will be completed by late August.
How this will affect your organization:
Before this feature update, when a user created an Office Script, their script was saved to their OneDrive for Business, and the owner of the script was the only user who had edit permissions to that script. Now, team members can easily collaborate, edit, view, and run team-owned scripts on their Excel workbooks. Additionally, because script files saved to a SharePoint site follow SharePoint file retention policies, these scripts can be used even after the creator leaves the organization.
Note: SharePoint support for Office Scripts is continuing to be rolled out. You may not see the feature right away.
What you need to do to prepare:
If you do not want users to be able to save their scripts to a SharePoint site so that others can view and run their scripts, please visit the Office Scripts admin pane to disable the feature by late July.