Fix Unable to Switch Microsoft 365 Users in SharePoint or Excel
Question details
The user is unable to sign in as a second user because SharePoint automatically opens a shared Excel workbook using an already signed-in organizational account.

- Product
- Microsoft 365, SharePoint, Excel
- Device & OS
- not provided
- Scenario
- Multiple users need to access shared Excel workbooks on the same device using different organizational accounts.
- Observed behavior
- SharePoint defaults to the existing signed-in organizational account and prevents the second user from successfully signing in or switching accounts.
Verify which Microsoft 365 accounts are currently signed into your Office applications, and ensure you have administrative privileges on the device if you need to configure shared computer activation.
Configure Shared Computer Activation for Microsoft 365
If multiple users must share the same physical computer, enabling Shared Computer Activation allows each user to sign in with their own credentials without token conflicts.
By default, Microsoft 365 Apps are activated for a single user on a device. When another user from the same organization tries to sign in, the system defaults to the first user's token. Shared Computer Activation bypasses this limitation.
Press the Windows key + R, type 'regedit' in the Run dialog, and press Enter to open the Registry Editor with administrator privileges.
Go to the following path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration.
Right-click in the right pane, select New > String Value, name it 'SharedComputerLicensing', and set its value data to '1'.
Close Registry Editor and restart your computer or all Microsoft 365 applications to apply the new shared licensing configuration.

Use Excel Co-Authoring Online
Avoid local account conflicts entirely by having users edit the shared document simultaneously through their web browsers.
Use Separate Windows User Profiles
Isolate user environments at the operating system level to completely separate Microsoft 365 activation tokens.
Try WPS Office for Hassle-Free Document Collaboration
If managing multiple Microsoft 365 organizational accounts on shared computers is causing login conflicts, consider switching to WPS Office. It provides a highly compatible, lightweight alternative that doesn't strictly lock device usage to a single organizational tenant.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, complete the quick setup process, and open WPS Spreadsheets.
- 3. Open Your Spreadsheets: Open your shared .xlsx files directly in WPS Office to view and edit them without Microsoft 365 tenant login conflicts.

Frequently Asked Questions
Why does SharePoint automatically open my Excel file with someone else's account?
This happens when Office desktop applications are already authenticated with another organizational account on the same computer. The software prioritizes the existing cached token for that organization.
Can two users from the same organization sign into Microsoft 365 desktop apps on the same PC simultaneously?
By default, no. Microsoft 365 prevents multiple accounts from the same tenant from signing into the desktop apps simultaneously. You must configure Shared Computer Activation to support this scenario.
Does clearing Windows Credentials solve the SharePoint login issue?
Clearing credentials via the Windows Credential Manager can temporarily remove the first user's account, allowing the second user to sign in, but it does not permanently allow both accounts to coexist in standard activation mode.
How do I correctly switch accounts in Excel without triggering an error?
To switch accounts safely on a standard setup, you must sign out of the current account in Excel (File > Account > Sign Out), close all Office applications, and then open Excel again to sign in with the new account.




