By the end of October, Office Scripts will be on by default.
What are they?
Office Scripts is a feature that enables you to create and record scripts to automate your repetitive tasks in Excel Online.
You can find full details on how to use them here.
How can I manage this?
This feature is on by default, so to manage how Office Scripts is used in your business, go to the M365 admin center, select Settings > Org settings. Then, select Office Scripts to view the Office Scripts admin controls. If you would like to disable this feature, you need to do so by 1st October, 2020.
- To block Office Scripts use in your business, deselect ‘Let users automate their tasks in Office on the web’. This will hide the Automate tab for everyone in your tenant.
- This feature is on by default. Should you disable and then wish to enable the feature, select ‘Let users automate their tasks in Office on the web’. The global admin can choose to either allow all users access or create a specific group of users who have access to Office Scripts.
- Once the ‘Let users with access to Office Scripts share their scripts with others in the organization’ checkbox is selected, the global admin can also choose whether or not a user can share scripts within an organisation. No external sharing is allowed.