question

25362085 avatar image
0 Votes"
25362085 asked emizhang-msft commented

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

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]


office-excel-itpro
image.png (14.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viorel-1 avatar image
0 Votes"
Viorel-1 answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @25362085,
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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @25362085,
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.


0 Votes 0 ·