Skip to Content

MC394517: Run team-owned Office Scripts in Excel for the web

Updated September 9, 2022: We have updated the rollout timeline below. Thank you for your patience.

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.

Office Scripts is an automation feature-set in Excel for the web. With this new feature, users will be able to save their scripts to a SharePoint site so that their team members can more easily collaborate, view, and run team-owned scripts on their Excel workbooks.

MC394517: Run team-owned Office Scripts in Excel for the webWhen this will happen

This change will begin rolling out in late July and will be completed by early October (previously 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.

Learn More

Message ID: MC394517
Published: 21 June 2022
Updated: 09 September 2022
Action required by: 29 July 2022
Platform: Web, World tenant

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.