Office Scripts has to be enabled through the Microsoft 365 Admin Center.
Login to Office Online.

Select Admin and show Show All on the left hand side.
Choose Settings > Settings and on the right hand side find the item Office Scripts.

Click on "Office Scripts" to display a new window.

Check "let users automate their tasks in Office on the web" checkbox.
Click "save changes".
Open Excel Online and launch a new blank workbook.
An additional tab will be displayed called "Automate".

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext