Permission & Access Issues

Fix Excel Error: Signed-In Account Cannot Open Protected Workbook

Huma Ashraf ChHuma Ashraf Ch Nov 2, 2026 868 views

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.

Fix Excel Error: Signed-In Account Cannot Open Protected Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Credential Manager

Click the Windows Start menu, type 'Credential Manager', and press Enter, or navigate to Control Panel > User Accounts > Credential Manager.

2
Access Windows Credentials

Select the 'Windows Credentials' tab to view all saved passwords and authentication tokens on your local machine.

3
Remove Office Credentials

Scroll through the list and locate any items that begin with 'MicrosoftOffice'. Click the drop-down arrow next to each one and select 'Remove'.

4
Restart Excel and Sign In

Close the Credential Manager, restart Excel, and sign in to your Microsoft 365 account again before attempting to open the workbook.

Clear Outdated Office Credentials in Windows
Safe Process: Removing credentials will not delete your files or data; it simply forces Microsoft Office applications to prompt you for your login details again.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free software on your computer.
  2. 2. Open the Protected File: Launch WPS Spreadsheets, click on 'Open', and browse your computer to select the password-protected Excel workbook.
  3. 3. Enter the Password: When prompted by WPS, simply enter the standard workbook password you originally set to unlock and edit your data.
Highly compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Handles standard password-protected files efficiently without tying them to cloud accounts.Free and lightweight, requiring fewer system resources than Microsoft 365.Familiar user interface for a seamless transition from Microsoft Office.
microsoft office alternative - wps office

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.