I don't see the Automate tab in the Office Excel.

설서진 1 Reputation point
2022-04-06T00:19:06.083+00:00

I need an Automate tab to use macros in Excel.
But I don't see it.
I can't even see the option

Please help me.

![190299-image.png]1

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,811 Reputation points Microsoft Vendor
    2022-04-06T07:09:05.077+00:00

    Hi @설서진 ,
    What kind of Office plans are you using?
    Please make sure you're using one of the following plans:
    1. Microsoft 365 Business Standard
    2. Microsoft 365 Apps for business
    3. Microsoft 365 Apps for enterprise
    4. Office 365 E3
    5. Office 365 E5
    6. Office 365 A3
    7. Office 365 A5

    If you're using the correct plan, you should contact your administrator, in the Microsoft 365 admin center, go to the Settings- Org settings= Services tab- Select Office Scripts.
    Make sure the feature: Let users automate their tasks in Excel on the web is turned on.

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

  2. Viorel 114.6K Reputation points
    2022-04-06T05:56:15.95+00:00

    I think that you must use the Excel desktop application instead of Excel for web. Try selecting "Open in Desktop App" from the "Editing" button.

    0 comments No comments

  3. Ken Burns 0 Reputation points
    2023-02-04T01:12:54.7366667+00:00

    The Automate tab may not be available in your version of Excel. The Automate feature was introduced in Microsoft Office Excel 2007 and is not available in earlier versions. If you are using an older version of Excel, you may not see the Automate tab.

    In addition, the Automate tab may not be visible if you have not enabled the Developer tab in Excel. The Developer tab provides access to advanced features and tools for Excel, including the Automate feature. To enable the Developer tab, follow these steps:

    1. Click the File menu.
    2. Click Options.
    3. Select Customize Ribbon.
    4. In the right-side panel, check the box next to Developer.
    5. Click OK to save the changes.

    The Developer tab should now be visible in the ribbon, and you should be able to access the Automate feature.


  4. Ken Burns 0 Reputation points
    2023-02-04T01:24:17.4933333+00:00

    The Automate tab may not be available in your version of Excel. The Automate feature was introduced in Microsoft Office Excel 2007 and is not available in earlier versions. If you are using an older version of Excel, you may not see the Automate tab.

    In addition, the Automate tab may not be visible if you have not enabled the Developer tab in Excel. The Developer tab provides access to advanced features and tools for Excel, including the Automate feature. To enable the Developer tab, follow these steps:

    1. Click the File menu.
    2. Click Options.
    3. Select Customize Ribbon.
    4. In the right-side panel, check the box next to Developer.
    5. Click OK to save the changes.

    The Developer tab should now be visible in the ribbon, and you should be able to access the Automate feature.

    0 comments No comments

  5. nguyen giang 0 Reputation points
    2023-11-05T16:54:31.1833333+00:00

    I have the same issue, I'm using excel 365 family on beta version 2311 and I cannot see the Automate tab even I can select it in my option. this is the joke where the individual person try to use personal excel to study what is only available in business level -> I'm sure this is not roll out on future, I'm looking for python, simple program language can be applied for all kind of person / excel products.

    0 comments No comments