How to Stop Excel Asking Whether to Use Work or Personal Account
Question details
The user needs to prevent Excel from constantly prompting them to select between a work/school account and a personal account at login.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening Excel or attempting to sign in to Microsoft Office applications.
- Observed behavior
- Excel displays a recurring login prompt asking the user to choose between a 'Work or school account' and a 'Personal account' even though both options display the exact same email address.
Before modifying your Windows account settings or uninstalling programs, make sure you have your current Microsoft account passwords saved and close all running Office applications.
Remove Duplicate Office Installations and Run Online Repair
Resolve software conflicts causing the account prompt by removing redundant Office installations and repairing your current Office software.
Having multiple versions of Microsoft Office installed on your computer can cause authentication conflicts, leading to repeated sign-in prompts.
Press the Windows key, type 'Control Panel', and press Enter. Under the 'Programs' section, click on 'Uninstall a program' to view your installed applications.
Scroll through the list to find Microsoft Office. If you see multiple versions (e.g., Office 2019 and Microsoft 365), right-click the unnecessary or older installation and select 'Uninstall'.
Once the uninstallation is complete, restart your computer to ensure all temporary files and conflicting registry entries are cleared.
Go back to 'Programs and Features', right-click your remaining Microsoft Office installation, select 'Change', and choose 'Online Repair'. Follow the on-screen prompts to fix any remaining issues.
Disconnect Stored Work or School Accounts in Windows
Clear out conflicting cached credentials from Windows Settings that trick Excel into thinking multiple active accounts exist.
Switch to WPS Office for a Hassle-Free Spreadsheet Experience
Tired of dealing with confusing account prompts and login loops? WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy powerful spreadsheet tools without the burden of complex subscription and account management.
- 1. Download and Install: Download WPS Office for free from the official website and run the lightweight installer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly without navigating complex account prompts.
- 3. Edit and Save Seamlessly: Use the familiar interface to edit your data, then save it in its original Excel format to easily share with colleagues.
Frequently Asked Questions
Why does Excel show my email as both a work and personal account?
This happens when your work email address was registered as a personal Microsoft account before Microsoft restricted the use of work email addresses for new personal accounts. It creates two separate profiles, one managed by your IT department and one managed personally, under the exact same email address.
Will removing a duplicate Office installation delete my Excel files?
No, uninstalling a duplicate Microsoft Office application from the Windows Control Panel will only remove the software program. Your locally saved Excel files (.xlsx) and personal data will remain safe on your hard drive.
How do I rename my personal Microsoft account to stop the confusion?
You can change the primary alias of your personal account to resolve the conflict. Sign in to your Microsoft account on the web, go to 'Your info', select 'Edit account info', and add a new personal email address as your primary alias, removing the work email from the personal profile.
