Fix Excel Error: Signed-In Account Cannot Open Protected Workbook
Question details
The user is unable to open a password-protected Excel workbook because the application claims the signed-in Microsoft 365 account lacks the necessary permissions, despite the user being the file's creator.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to open a password-protected workbook created by the user.
- Observed behavior
- Excel requests a Microsoft 365 account authentication and then displays an error stating the signed-in account does not have permission to open the protected file.
Ensure you have the correct password for the protected workbook and verify that your device has an active internet connection to authenticate your Microsoft 365 account.
Clear Outdated Office Credentials in Windows
Clearing old or corrupted Microsoft Office credentials from the Windows Credential Manager can resolve account authentication conflicts preventing file access.
Often, Excel caches old login tokens that conflict with your current Microsoft 365 session. Removing these from Windows forces Excel to generate a fresh, correct authentication token.
Click the Windows Start menu, type 'Credential Manager', and press Enter, or navigate to Control Panel > User Accounts > Credential Manager.
Select the 'Windows Credentials' tab to view all saved passwords and authentication tokens on your local machine.
Scroll through the list and locate any items that begin with 'MicrosoftOffice'. Click the drop-down arrow next to each one and select 'Remove'.
Close the Credential Manager, restart Excel, and sign in to your Microsoft 365 account again before attempting to open the workbook.

Verify Signed-In Account and Test on Another Computer
Confirming your active account in Excel and testing the file on a different device helps isolate whether the issue is local to your machine or tied to the file itself.
Contact Your Organization Administrator
If local troubleshooting fails, your organization's IT admin may need to check tenant-level permission settings or escalate the issue.
Use WPS Office to Open and Manage Protected Spreadsheets
If Microsoft Excel continues to block your access due to account permission bugs, consider trying WPS Office. It is a lightweight, free alternative that perfectly supports Microsoft Excel formats (.xlsx, .xls) and standard password protection without complex account permission conflicts.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free software on your computer.
- 2. Open the Protected File: Launch WPS Spreadsheets, click on 'Open', and browse your computer to select the password-protected Excel workbook.
- 3. Enter the Password: When prompted by WPS, simply enter the standard workbook password you originally set to unlock and edit your data.

Frequently Asked Questions
Why does Excel ask for an account when I only set a password?
Microsoft 365 sometimes triggers account authentication for protected files to verify user licensing or because Information Rights Management (IRM) policies were unintentionally applied alongside the standard password.
Will my data be lost if I cannot sign in to Excel?
No, your data remains safely encrypted within the file. If the issue is an account glitch, opening the file on another computer or using alternative spreadsheet software like WPS Office with the correct password will restore your access.
How do I remove a password from an Excel file once it is open?
Navigate to File > Info > Protect Workbook > Encrypt with Password. Clear the existing password from the text field, click OK, and save the document to permanently remove the password protection.




