Skip to main content

Notifications

Community site session details

Community site session details

Session Id : GmxauIPLYvYa63gXMMhmUl
Power Automate - General Discussion
Answered

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

Like (1) ShareShare
ReportReport
Posted on 8 Sep 2023 01:46:27 by 68

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

  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 08 Sep 2023 at 05:12:49
    Re: Office Scripts is enabled but no automate bar in excel online.

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

     

     

  • Anya0601 Profile Picture
    68 on 08 Sep 2023 at 05:06:30
    Re: Office Scripts is enabled but no automate bar in excel online.

    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.

     

     

  • Verified answer
    trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 08 Sep 2023 at 03:37:24
    Re: Office Scripts is enabled but no automate bar in excel online.

    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.

     

     

     

  • Anya0601 Profile Picture
    68 on 08 Sep 2023 at 03:33:14
    Re: Office Scripts is enabled but no automate bar in excel online.

    @trice602  Office 365 E1

  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 08 Sep 2023 at 03:27:18
    Re: Office Scripts is enabled but no automate bar in excel online.

    Hi @Anya0601 ,

     

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

     

     

  • Anya0601 Profile Picture
    68 on 08 Sep 2023 at 03:17:42
    Re: Office Scripts is enabled but no automate bar in excel online.

    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.

  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 08 Sep 2023 at 02:54:21
    Re: Office Scripts is enabled but no automate bar in excel online.

    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

     

     

  • Anya0601 Profile Picture
    68 on 08 Sep 2023 at 02:42:23
    Re: Office Scripts is enabled but no automate bar in excel online.

    Hi,

     

    I tried that and failed to see any automate tab neither under Developer nor in the left side.

    Anya0601_1-1694140812548.png

    And I use Microsoft Office Professional Plus 2016.

     

  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 08 Sep 2023 at 02:06:31
    Re: Office Scripts is enabled but no automate bar in excel online.

    Hi @Anya0601 ,

     

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

     

    trice602_0-1694138733564.png

     

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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started