Dear 06SCE,
Good day! Thank you for posting to Microsoft Community. We are happy to help you.
As per your description, please don’t worry, we can work together to narrow down and resolve the situation.
Based on my test on different Office 365 business account and education account in Excel for webs(online0 it seem that I cannot meet the same behavior as like you descried above. Here is my test screenshot for your reference.
Since, you mentioned, only one account have problem and to check your specific scenario, it might be possible from Office 365 Admin it turn off the Office Scripts or turn on for only specific user feature in Excel. If possible could you please, try to let Office 365 admin and check the below setting.
If the setting is already correct please try to let them disable and re-enable it to check the result.
Here is below some suggestion, you may try to check if there is any difference:
1. Clear out your cookies
2. Enable third party cookies (this one is mandatory for the Automate tab to appear I'm afraid)
3. Use use another bowser or In-private browser to check if there is any difference.
Meanwhile, may I know does the problem happened to specific Excel file? if possible could you please go to your problematic account and click on OneDrive and create a new Excel file online and verify the behavior with us, it will help for us to narrow down your issue.
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.
Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!
Sincerely,
Waqas Muhammad
