Permission & Access Issues

How to Use One Primary Account for OneDrive and SharePoint Across Tenants

Natalie Taylor Oct 10, 2026 868 views

Question details

The user wants to configure Microsoft Office to open all OneDrive and SharePoint documents from multiple tenants using a single primary account, even when secondary tenant emails are registered in Outlook.

How to Use One Primary Account for OneDrive and SharePoint Across Tenants

Product: Microsoft Office, OneDrive, SharePoint
Device & OS: not provided
Scenario: A user is synchronizing files from multiple tenants using B2B collaboration and needs to manage multiple email addresses in Outlook without affecting the primary document identity in Word and Excel.
Observed behavior: Office automatically selects the account associated with the document's original location (Tenant 2 or 3) instead of the primary account, because the additional email accounts are globally registered in Windows and Office.

Before you start

Ensure that your primary account has the necessary edit permissions in each SharePoint location across all tenants, and verify that B2B collaboration is properly enabled.

Solution 1Recommended

Add Secondary Accounts Exclusively to Outlook

Prevent Office from automatically switching document identities by adding secondary tenant emails only to Outlook, rather than registering them system-wide in Windows.

When multiple email accounts are registered at the Windows or Office level, Office automatically selects the identity associated with a document's sync location. To prevent this, additional mailboxes should be isolated to Outlook.

Remove Secondary Accounts from Windows

Open Windows Settings, navigate to Accounts, and select 'Email & accounts'. Remove the secondary tenant accounts if they are currently registered globally.

Open Outlook Account Setup

Launch Microsoft Outlook and go to the settings to add your secondary tenant mailboxes.

Select the Outlook-Only Option

During the authentication prompt for each secondary mailbox, look for and select the option to add the account 'only to Outlook'. Skip any prompts that ask to 'allow my organization to manage my device' or register the account with Windows.

Add Secondary Accounts Exclusively to Outlook

Identity Selection Behavior: There is no universal setting that forces every tenant document to open under one account. Office inherently respects the identity tied to the document's sync location if the account is accessible system-wide.

Solution 2

Manage B2B Cross-Tenant Synchronization

Use your primary account as a guest in other tenants to synchronize files, minimizing the need to log into secondary accounts.

Free Microsoft Office alternative

Try WPS Office for Simplified Document Management

If managing multiple Microsoft tenant accounts, identity settings, and permissions is becoming overly complex, consider WPS Office as a lightweight, highly compatible alternative that handles local files without forcing cloud identity switches.

1. Download WPS Office: Visit the official WPS Office website to download the free installation package.
2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
3. Open Your Documents: Launch WPS Office and open your synced local documents without dealing with automatic tenant account switching.

Free and lightweight office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formatsAvoid complex Windows-level tenant account restrictionsFamiliar, tabbed user interface for easy multitasking

microsoft office alternative - wps office

Frequently Asked Questions

Why does Office open my document with a different tenant account?

Office automatically selects the identity associated with the synchronized folder or document's original location if that secondary account is registered in your Windows or Office settings.

Is there a setting to force all Office files to open with one specific account?

No, there is no universal setting in Microsoft Office that forces every document from multiple tenants to open under a single primary account. Office relies on the document's source and available identities.

Can I add emails to Outlook without affecting Word or Excel?

Yes. When adding a new mailbox in Outlook, ensure you select the option to add the account 'only to Outlook' and decline any prompts to register the account with Windows or allow the organization to manage your device.

Document & File Issues