Microsoft 365 features that help users manage their subscriptions, account settings, and billing information.
Hi @AW
Please understand that our forum is a public platform, and we will modify your question to cover your personal information including your organization domain name, ID in the description. Please notice to hide these personal or organization information next time you post error or some information to protect personal data.
I have moved the information to the Private message if you need to add any more privacy information please add it in there.
Regarding your issue, the error indicates that the workbook is attempting to access a Microsoft 365 resource (such as a link, embedded connection, or sign‑in context) that belongs to another tenant. Because your account doesn’t exist in that tenant, Excel keeps prompting you to sign in and throws the AADSTS50020 message. This can happen even if you personally have no connection to that organization, as the reference may be embedded in the file itself or tied to a previous sign‑in context.
For more details, please refer to: Error AADSTS50020 - User account from identity provider does not exist in tenant
Also, may I kindly ask a few questions to help understand it better:
- Where are the affected files stored (for example: local drive, OneDrive, SharePoint, or email attachment)?
- Were these files created by you, or were they shared or received from someone else?
- If you open the same file in Excel on the web, do you see the same error?
- When the pop‑up appears, are you signed into Excel with any work or school account (check under File > Account)?
- When the file is open, do you see anything listed under Data > Queries & Connections > Workbook Links? If you see any links or connections pointing to an unfamiliar organization, try removing or breaking those links to see if it helps with your issue. For more details, please refer to: Manage workbook links
Hope to hear back from you soon.
The initial response may not fully address your needs, but it will help me better understand your situation. Once I get the information, I will try my best to find the next steps.
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.