×

How To Enable Office Scripts For Excel Online

By Chris Newman •  Updated: 03/28/20 •  3 min read
Enable Office Scripts Excel Online

Excel for the web (aka Excel Online) now has scripting functionality akin to VBA! We are in the early stages of this new scripting language, however, if you would like to get a head start in learning this new language to automate tasks on Microsoft’s online Apps (this does not work for Desktop apps…for now), you may be able to convince your Admin to turn on this new feature. The code editor and script recorder are located on the Automate tab in Excel which is hidden by default. The following brief tutorial will show admins how to enable this feature.

Script Editor

Further Script Documentation

Who Can Use This?

This feature is in preview and only available to users in E3 Tenants and E5 Tenants that have had their admin enable Scripts for Excel Online.

Accessing the Admin Center

To access the Admin Center on Office 365 you will need to log into Office.com and select the Admin App on your dashboard. If you do not see the Admin App, you can click the right arrow icon to view all your apps. In the event you cannot find the Admin App after viewing all your apps, chances are you do not have Admin rights.

Open Admin Center

Open Admin Settings

Once you’ve clicked the Admin App, you should be taken to a new webpage with a pane menu on the left-hand side. You will need to select Settings > Settings. If you do not see an Settings menu option, you may need to click the Show All option at the very bottom of the listing.

Select Settings

Open Office Scripts Settings

After you have navigated to the Settings section, ensure you are in the Services part of the settings and click the Office Scripts option.

Office Scripts Settings

Enable Office Scripts

After opening the Office Scripts Settings, you should see a pane to the right of your screen. You should see a checkbox option similar to below that will allow you to enable Office Scripts.

Enable Office Scripts

Access Office Scripts

After Office Scripts have been enabled by your Office Admin, you can refresh Excel Online (you may need to close out of it completely) and after reopening, you should see a new tab in your Ribbon called Automate. There will most likely be more button residing in this tab in the future, but for now you have access to a Script Recorder (online version of the Macro Recorder) and a Code Editor pane.

For more information on what all Scripts can do, check out the Microsoft documentation.

Excel Online Automate Tab

I Hope This Helped!

Hopefully, I was able to explain how you can enable this new feature for Excel Online. While scripting is still a work in process, there is a lot of automation you can carryout within Excel and in combination with Power Automations to automate your cloud activity. If you have any questions about this technique or suggestions on how to improve it, please let me know in the comments section below.

Keep Learning

Chris Newman

Chris Newman

Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X