Office Scripts is enabled but no automate bar in excel online.

(1) Share

Report

Posted on by Anya0601

Hi,

I am working on a project with Power Automate Cloud Flow and have to populate online excel with Office Scripts.

However, I don't see any Automate bar in excel online. so I checked with the IT team who has the access to microsoft admin center. and he said that Office scripts have already been enabled for a long time.

My question is how can I see the Automate bar in excel online? I can't move forward without the functionality of Office Scripts.

Thanks,

Anya

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anya0601 ,

Can you confirm this is checked in your Options > Customize Ribbon > Automate (may also be under Developer tab in earlier versions)?

This is in your Excel application, not in your browser.

Was this reply helpful? Yes No
Anya0601 68 on at

Like (1)

Report

Hi,

I tried that and failed to see any automate tab neither under Developer nor in the left side.
And I use Microsoft Office Professional Plus 2016.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anya0601 ,

I don't think it is available for a stand-alone version and is the root cause. Please see documentation for clarification:

Platform limits and requirements with Office Scripts - Office Scripts | Microsoft Learn

Was this reply helpful? Yes No
Anya0601 68 on at

Like (1)

Report

Thank you @trice602

Just one clarification, I'm actually using Excel for the web to do cosmetic changes and data manipulations for my tables, and then connect to Power Automate flows for other operations. Does that mean I can't have Automate ribbon (Office Scripts) in Excel for the web when I have Excel Desktop app which is incompatible given my IT tenant admin has already activated the function?

Cheers.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anya0601 ,

Do you know what license you have E1, E3, E5, or something similar?

Was this reply helpful? Yes No
Anya0601 68 on at

Like (1)

Report

@trice602 Office 365 E1

Was this reply helpful? Yes No
Verified answer

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Thanks @Anya0601 for sharing. Ok, I believe that is the root cause. E1 does not come with Office Script access and don't think this is an Excel version issue. I would ask your I/T department to upgrade you to an E3 and see if that solves this for you.

You can maybe also share this link with your I/T department:

https://learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits

If this discussion was helpful, please mark as a solution so others with the same challenge can find the discussion, documentation, and licensing limitations discussed here.

Was this reply helpful? Yes No
Anya0601 68 on at

Like (1)

Report

Hi @trice602 ,

Thank you for your kindly help. I have checked with a colleague who has E3 license and is able to utilize Office Scripts. So that's probably the root cause. I'll contact with the IT team to upgrade my license.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Nice! Glad there's a path forward and you know what you need. Tom

Was this reply helpful? Yes No