Dear Terrence,
Good day! Thank you for posting in Microsoft Community. We are happy to help you.
From your description, it seems that one of your organization account doesn’t show Automate tab in Excel for web, and another account doesn’t have this problem.
If my understanding is right, we have also tested it on our side and we can see Automate tab without any problem.
Since you mentioned this issue occurs several days ago, we’d suggest you let this user change another browser to check if the same problem will occur.
At the same time, please also contact Office 365 administrator to go to Office 365 admin center > Settings > Org Settings > Office Scrip[ts > then check if Office 365 administrators only enable such feature for specific users, as shown below:
If the suggestion above don’t work and all Excel files have the same problem, given this situation, we do understand the inconvenience caused by it. Since we cannot reproduce the same situation as yours and only one user has this problem, we assumed this issue may be related to specific account and may need to be checked from background. The best way to troubleshoot the issue is to report the issue to the related Team. We’d suggest you contact your office 365 administrator to go to Office 365 Admin Center-> Support-> New Service Request, the support engineers there have the correct escalation channel and this is the most efficient way to report such issue. You can refer to this article to check the way how to raise a ticket. Ways to contact support for business products - Admin help.
If the scenario above is not consistent with yours, you can also post back and point that.
Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!
Sincerely,
Sukie| Microsoft Community Moderator