A Microsoft file hosting and synchronization service.
Hi @Paula Bledsoe,
Thank you for posting your question on the Microsoft Q&A Forum.
The error you encountered:
AADSTS50020: User account does not exist in this tenant and cannot access the application… The account needs to be added as an external user…
occurs because the account ******@xxxxxxko.com is not part of the Azure AD tenant associated with the resource you are trying to access. The application you’re signing into requires an account that either:
- belongs to that specific tenant, or
- has been added as a Guest (External User) in the tenant.
Since it’s unclear whether your personal Gmail account is set up as a guest in this tenant, I’m providing guidance based on the tag used in your original post. If your account hasn’t been added as an external guest yet, please let me know so I can give you more accurate instructions.
You can clear your credentials cache, remove all of your Microsoft password and usernames from your computer to ensure a clean reset
- Please sign out your accounts from Office applications, then close all Office applications.
- Open File Explorer, paste the following path, and delete all files and folders. %localappdata%\Packages\Microsoft.AAD.BrokerPlugin_cw5n1h2txyewy
- Go to settings > Accounts > Access work or school
- Check if you can see your school account in "Access Work or School".
If you can see it, please select it and select Disconnect. After that, please click "Connect" and log into your business account again to register the device.
Clear Cached Credentials
- Open the Control Panel on your PC.
- Go to User Accounts → Credential Manager.
-
- Under both Windows Credentials and Generic Credentials, look for any entries related to your Microsoft 365 account.
- Select and remove those entries.
- Restart your computer and try adding your account in Office again.
Download OLicenseCleanup.vbs and run it. In this way, you can use this package to remove license, remove cached identities in HKCU registry and remove credentials. For more details, you can refer to this article: Reset Microsoft 365 Apps for enterprise activation state.
Reboot your device.
Log in to your Excel via Office.com in Incognito/ Private mode to see if the issue persists.
Reopen Office apps and sign in with the correct account.
You can read about this error via this article: Error AADSTS50020 - User account from identity provider does not exist in tenant | Microsoft Learn
If the issue persists after completing the steps, the next best step would be to contact your organization’s IT administrator. They can help investigate the problem in more detail and verify whether any Group Policies or other security settings are being applied to your account or device that may be restricting this functionality. Additionally, your IT administrator may be able to submit a support ticket to Microsoft on your behalf via Microsoft 365 Admin Center to obtain official guidance and solutions for restoring access and ensuring that Excel is fully functional for your needs.
I hope this information is helpful. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.
I look forward to continuing the conversation.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Note: Follow the steps in our documentation to enable email notifications if you want to receive email notifications related to this topic.