How to Resolve SharePoint Site Access Issues with Duplicate Accounts
Question details
A team member is unable to properly access a SharePoint site due to a conflict between a company Microsoft 365 tenant account and a separate personal account that share the same email address.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A user attempts to open a SharePoint invitation link from their email but encounters authentication conflicts caused by duplicate Microsoft accounts.
- Observed behavior
- The user cannot log in with the correct company tenant account. They can access the site using the secondary/personal account, but the site fails to open correctly within the desktop application.
Verify that you have Site Owner or Full Control administrator privileges for the SharePoint site before modifying access permissions and groups.
Remove and Re-grant Access via Advanced Permission Settings
Clear out any conflicting account records by completely removing the user from the site's directory, then carefully re-invite the correct Microsoft 365 tenant account.
When duplicate accounts exist, SharePoint can cache the incorrect user profile. Removing the user entirely from the site's 'People and Groups' ensures that the old permission token is destroyed before a new one is generated.
Click the gear icon (Settings) in the top-right corner of your SharePoint site and select 'Site permissions' from the dropdown menu.
Scroll to the bottom of the permissions pane and click on 'Advanced permission settings' to view the detailed user and group lists.
Navigate to the site's 'People and Groups' page. Locate the user experiencing the issue, check the box next to their name, click 'Actions', and select 'Remove Users from Group'.
In the Advanced permissions page, click 'Grant Permissions'. Enter the user's email address and ensure you select the profile connected to the company Microsoft 365 tenant, not the personal account.
Ask the user to open the newly generated invitation link or type the direct SharePoint site URL in a private/incognito browser window to force a fresh login with the correct work account.
Looking for a Hassle-Free Office Suite?
Dealing with complicated tenant permissions and duplicate Microsoft accounts can slow down your team. WPS Office provides a lightweight, intuitive, and highly compatible workspace for your document needs without the hassle of complex cloud account management.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to complete the setup in minutes.
- 3. Open and Edit Seamlessly: Launch WPS Office and immediately start opening, editing, and saving your existing Microsoft Office documents without format loss.
Frequently Asked Questions
Why does a user have two Microsoft accounts with the same email address?
This typically occurs when a user previously used their work email to register for a personal Microsoft account (like Xbox or Skype), and later, the same email was provisioned by their organization as an official Microsoft 365 work or school account.
How can the user guarantee they are signing in with the correct account?
When prompted to log in to SharePoint, the user should always select the 'Work or school account' option instead of the 'Personal account' option. Using an incognito or private browsing window can also prevent the browser from automatically logging into the wrong cached account.
Why does the SharePoint site fail to open correctly in the desktop app?
Desktop applications (like Word or Excel) authenticate using the primary Microsoft account signed into the local Office client. If the user accesses the web link with their personal account but their desktop apps are signed into a different account, the authentication token handoff fails. The user must ensure their desktop apps are signed into the exact same Microsoft 365 tenant account.
