How to Switch Between Personal and Work Accounts in Excel and Sign Out Properly

You might need to use different Microsoft accounts for personal and work files in Excel. This often happens when your organization uses a separate Microsoft 365 subscription. Excel can manage multiple signed-in accounts, but switching between them or signing out requires specific steps. This article explains how to change your active account and sign out completely from Excel on Windows.

How Excel Handles Multiple Microsoft Accounts

Excel for Microsoft 365 supports having several Microsoft accounts signed in simultaneously. Your personal account might be a standard Outlook.com or Hotmail address. Your work account is typically provided by your company’s IT department and ends with your organization’s domain. Excel uses one account as the active user at any time. This active account determines where new files are saved by default to OneDrive and which SharePoint sites appear in the Open dialog. Other signed-in accounts remain available for quick switching. You need an active internet connection to sign in or switch accounts for the first time. After that, Excel can use cached credentials to keep you signed in.

Account Types and Permissions

Work or school accounts often have stricter security policies set by administrators. These can include mandatory multi-factor authentication or restrictions on where you can save files. Personal accounts have the settings you configure yourself. When you open a file stored in a work OneDrive or SharePoint location, Excel may prompt you to sign in with the correct work account if it is not already active. The account management features are the same in Excel for Windows, but the sign-in experience is built into the Windows security system.

Steps to Switch Your Active Account in Excel

Switching accounts changes which user profile is currently in use for saving and opening files. Other accounts remain signed in and available.

1. Open the Account menu
   Launch Excel and open any workbook. Click the File tab in the top-left corner to go to the Backstage view. Then select Account from the list on the left side.
2. View your user information
   On the right, under the User Information section, you will see your currently active account name and photo. Below that, you will see all other accounts that are currently signed in.
3. Initiate the switch
   Click the Switch account button. A window will appear showing all your signed-in Microsoft accounts.
4. Select the new account
   Click on the personal or work account you want to make active. Excel will refresh the interface, and the selected account will now appear at the top of the User Information section.

How to Sign Out of an Account in Excel

Signing out removes your profile and credentials from the Excel application. This is useful on a shared computer.

1. Go to File > Account
   In an open Excel workbook, click File and then select Account.
2. Choose the sign-out option
   Under your active user information, click the Sign out link. A confirmation dialog will appear.
3. Confirm the sign-out
   Click Sign out again in the confirmation dialog. Excel will close all open workbooks and restart. You will be prompted to sign in with an account when it reopens.

Signing Out All Accounts

To sign out of every account, you must repeat the sign-out process for each one. Start by switching to the first account, signing out, and then repeating for the next account when Excel restarts. There is no single command to sign out of all accounts at once.

Common Mistakes and Limitations

Excel Still Shows Old Account in Save Dialog

After switching, the Save As dialog might still show OneDrive folders from a previous account. This happens because Windows caches account information. To fix this, completely close Excel and restart the application. The Save As locations should then update to reflect the new active account.

Can’t Sign Out of a Work Account

If the Sign out link is grayed out for a work or school account, it is managed by your organization’s IT policies. The account was likely added through Windows Settings. You must remove it at the system level. Go to Windows Settings > Accounts > Email & accounts. Select the work account and click Remove. You may need administrator approval on your PC.

Switching Accounts Does Not Change License

The active account in File > Account is for user identity. The product license, which determines available features, is tied to the account used to activate Microsoft 365. If you have a work license, you will see “Product Activated” under your work account. Switching to a personal account does not change the licensed feature set; you will still have access to work features.

Account Management Methods Compared

Item	Switch Account	Sign Out	Remove Account via Windows
Primary Use	Change active user for file access	Clear credentials from Excel app	Delete account from the entire PC
Effect on Other Accounts	Other accounts stay signed in	Only affects the selected account	Removes all traces of that account
Best For	Daily use with multiple accounts	Using a shared computer temporarily	When leaving a company or device
Location in Excel	File > Account > Switch Account	File > Account > Sign Out	Windows Settings > Accounts

You can now manage personal and work profiles in Excel. Use the Switch Account feature to change contexts quickly during your workday. If you need to clear all data, remember to also check the Windows Accounts settings. For advanced control, use the Office Upload Center to clear cached files from a specific account’s OneDrive.