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 > Services and add-ins.
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: Office Scripts is currently in Targeted release. If you have enabled Office Scripts, but do not see the Automate tab, you will need to wait until the feature is released to your organization. Visit Set up the Standard or Targeted release options in Office 365 to learn how to opt-in to early feature releases.
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.