Fix Excel File Opening as Read-Only Without a Password
Question details
The user needs to troubleshoot an Excel workbook that automatically opens in read-only mode or prompts for a password that was never intentionally set.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open, edit, and save an existing Excel workbook.
- Observed behavior
- The file forces read-only mode or requests an unknown password, preventing normal edits and saves.
Before attempting to change file attributes or network permissions, save a backup copy of the problematic spreadsheet to your local desktop to prevent accidental data loss.
Check Local File and Folder Properties
If the file was copied from an external drive or downloaded from the internet, Windows may have automatically flagged its properties as read-only.
Windows operating systems often apply a read-only attribute to files transferred from other computers, USB drives, or downloaded from untrusted network locations. Disabling this attribute allows you to edit and save the document normally.
Open File Explorer and navigate to the folder where your Excel file is saved.
Right-click on the Excel file and select 'Properties' from the context menu.
In the General tab, look at the Attributes section at the bottom. Uncheck the 'Read-only' box.
Click 'Apply' and then 'OK'. Re-open the file in Excel to see if the issue is resolved.

Resolve Cloud Storage and Network Drive Conflicts
Files stored on OneDrive, SharePoint, or a shared network drive can become locked if another user has them open or if there is a synchronization error.
Disable 'Mark as Final' and Workbook Protection
The author may have marked the document as final or applied internal worksheet protection to prevent accidental edits.
Experience Hassle-Free Spreadsheets with WPS Office
If you frequently encounter frustrating read-only locks, complex OneDrive sync issues, or unexpected password prompts in Microsoft Excel, WPS Office offers a seamless alternative. It provides robust spreadsheet tools without restrictive background cloud locks, ensuring you always have fast access to your data.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Spreadsheets: Right-click your existing .xlsx files, select 'Open with', and choose WPS Spreadsheet.
- 3. Edit and Save Locally: Easily manage your data and save files directly to your local drive without forced cloud synchronization.

Frequently Asked Questions
Why does my Excel file say read-only when I am the only user?
This usually happens because the file's Windows attributes are set to read-only, the file was opened directly from an email attachment instead of being saved first, or a background process (like an antivirus scan or cloud sync) is temporarily locking the file.
Can I unlock an Excel file if I don't know the password?
If the file is encrypted with an open-password, it cannot be legitimately bypassed without the correct password. However, if it is only worksheet protection (restricting edits on certain cells), you can sometimes copy the unprotected data and paste it into a brand new workbook.
Why do email attachments always open as read-only?
Email clients open attachments in a temporary folder using Protected View to prevent malicious scripts from harming your computer. To edit the file, you must click 'Enable Editing' or save the file to your local Documents folder first.




