Office Scripts enables users to record, edit, and run automated scripts in Excel on the web. Office Scripts for Excel on the web is currently available in public preview, however, it is off by default. As an admin, you will need to activate Office Scripts for your organization.
The following steps describe how to toggle the Office Scripts feature for your users.
Sign in to Office 365 with your work or school account as a global admin.
In the Microsoft 365 admin center, choose Settings > Settings. You may need to select Show all first.
Select Office Scripts.
On the right, there is a checkbox labeled Let users automate their tasks in Office on the web. Check that box to activate Office Scripts. Leave it unchecked to disable this functionality for your organization
Note: The Office Scripts setting is only available when The new admin center is toggled on. Visit About the new Microsoft 365 admin center to learn more about the new admin center.
Note: Once you’ve toggled on the correct setting in the admin center, end users with an active Office 365 Enterprise E3 or Office 365 Enterprise E5 license will be able to access the feature. This feature is not yet available in Microsoft 365 for US Government and customers with data residency in one of the new local datacenter geos.
Office Scripts in Excel on the web is in preview and may change. If you encounter issues while using Office Scripts, let us know through Excel Feedback (Help > Feedback) or the OfficeDev/office-scripts-docs GitHub repository.