You may need to use Excel with different Microsoft accounts for personal and work projects. Excel can only be signed into one Microsoft account at a time, which controls your OneDrive access and file autosave. This article explains how to switch accounts directly within the application. You will learn the steps to sign out of one account and sign into another without restarting Excel.
Key Takeaways: Switching Microsoft Accounts in Excel
- File > Account > Sign out: Disconnects your current Microsoft account from Excel and closes the associated OneDrive connection.
- File > Account > Sign in: Opens a prompt to enter credentials for a different personal or work Microsoft account.
- Windows Start Menu > Settings > Accounts > Email & accounts: Manages the default Windows account, which can affect Excel’s sign-in dialog.
How Excel Manages Microsoft Account Sign-ins
Excel uses a single Microsoft account for cloud-based features. This account links to your OneDrive for Business or personal OneDrive storage. It enables the AutoSave feature for files stored in the cloud and manages your sharing permissions. You cannot be actively signed into two different Microsoft accounts within the same Excel window. Switching accounts is a manual process that changes the active user for all Office applications. Before switching, ensure any unsaved work is saved locally, as the change may briefly interrupt cloud connectivity.
Account Types and Licensing
Your work account is typically provided by your organization’s IT department and includes a Microsoft 365 license. A personal account is one you create yourself, like an @outlook.com or @hotmail.com address. The type of account determines which OneDrive service you access. Excel will display the account email address and subscription status at the top of the File > Account page. This helps you verify which identity is currently active before making a change.
Steps to Change Your Active Microsoft Account
Follow these steps to sign out of one account and sign into another. This process does not delete files or remove accounts from your computer. It only changes the active user within Excel.
- Open the Account page in Excel
Click the File tab in the top-left corner of the Excel window. In the backstage view, select Account from the left-hand menu list. - Sign out of the current account
Under the User Information section, click the Sign out button. A confirmation dialog may appear. Confirm you want to sign out. Excel will disconnect from cloud services, and AutoSave will turn off for any open cloud files. - Initiate the new sign-in
On the same Account page, the Sign in button will now be visible. Click the Sign in button. A Microsoft sign-in window will pop up. - Enter new account credentials
In the pop-up window, type the email address for the personal or work account you want to use. Click Next. Enter the password for that account on the following screen and complete any multi-factor authentication required. - Verify the account switch
Return to File > Account. The User Information section should now show the name and email address of the new account. The subscription product, like Microsoft 365, will also update to reflect the new account’s license.
Common Mistakes and Account Issues
Excel Shows the Wrong Account After Sign-in
Windows might automatically sign you in with a cached account. To fix this, use the Sign out button in Excel again. In the pop-up sign-in window, carefully check the email address shown. If it is wrong, click Use another account and manually type the correct email. Clear the browser cache in your default web browser, as Office uses this for authentication.
AutoSave is Unavailable After Switching
AutoSave only works for files saved to the OneDrive linked to your currently signed-in account. If you open a file stored on the other account’s OneDrive, AutoSave will be grayed out. Save a copy of the file to the desktop first. Then, move it manually to the OneDrive folder for your new active account to re-enable AutoSave.
Can’t Sign Out Because the Button is Missing
Some work accounts managed by an organization have security policies that prevent manual sign-out. In this case, you may need to switch accounts via the Windows settings. Go to Start > Settings > Accounts > Email & accounts. Remove the work account there, then restart Excel and sign in with the desired account.
Manual Switch vs. Windows Account Management
| Item | Switching in Excel (File > Account) | Managing in Windows Settings |
|---|---|---|
| Primary Use | Changing the active user for Excel and other Office apps | Changing the default Windows user or removing account credentials |
| Effect on Files | Disconnects cloud file access; local files unchanged | Can affect login for all apps and system-level services |
| Process Speed | Fast, within the app, no restart needed | Slower, may require app or system restart |
| Best For | Frequent switching between known accounts | Resolving persistent sign-in errors or removing old accounts |
You can now control which Microsoft account is active in Excel. Use File > Account to switch between personal and work profiles as needed. For a faster workflow, pin the Account page to your backstage view. If you manage multiple sets of files, consider using separate Windows user profiles for a completely isolated environment.