How to Remove Read Only in Excel: 6 Fixes for Different Causes

Opening an Excel workbook only to find that you cannot type, save changes, or edit a cell can be confusing because "read-only" is not one single Excel problem. The workbook may have been marked as final, opened with a read-only recommendation, restricted by Windows file properties, protected by the workbook owner, opened in Protected View, or temporarily locked by another user.

The fastest way to fix it is to identify what Excel is actually telling you before changing settings. The guide below starts with the message or behavior you can see on screen, then shows the safest way to restore editing access without weakening Excel's security protections unnecessarily.

Part 1. Why Is My Excel File Read-Only?

Excel can limit editing for several very different reasons. Some are simple document settings; others exist to protect a file from accidental changes or unsafe content. Before trying a fix, compare what you see with the situations below.

Part 2. How to Remove Read-Only in Excel

Use the method that matches the message or restriction you are seeing. You do not need to apply every fix.

1. Turn Off Mark as Final

Use this when: Excel says the workbook is marked as final or editing commands are disabled because the file was finalized.

Mark as Final is designed to discourage editing; Microsoft notes that it is not a security feature. If you are allowed to edit the workbook, you can turn it off.

Step 1. Open the workbook and choose File.

Step 2. Go to Info > Protect Workbook > Mark as Final. Select Mark as Final again to remove the status.

2. Remove the Read-Only Recommended Setting

Use this when: Excel asks whether you want to open the workbook as read-only, but you own the file and want it to open normally in edit mode.

Step 1. Open the workbook and choose File > Save As > Browse. In the Save As dialog, open Tools > General Options.

Step 2. Clear Read-only recommended. If a password to modify the file was intentionally set, remove it only when you have authorization to do so. Save the workbook.

3. Clear the Windows Read-Only File Attribute

Use this when: A local Excel file repeatedly opens read-only and the restriction appears to follow the file in Windows rather than an Excel protection message.

Step 1. Close the workbook. In File Explorer, right-click the Excel file and select Properties.

Step 2. On the General tab, clear Read-only if it is selected, then choose Apply and OK.

If the setting comes back or you cannot change it, check the folder permissions, cloud-sync state, or whether the file is stored somewhere you only have view access.

4. Remove Workbook or Sheet Protection

Use this when: The workbook opens, but protected sheets, cells, or workbook structure prevent the changes you need.

Excel protection is different from the Windows read-only attribute. If the workbook owner intentionally protected the file, you need the appropriate password or permission rather than a workaround.

Step 1. Open the workbook and go to the Review tab.

Step 2. Choose Unprotect Sheet or Protect Workbook as appropriate, then enter the authorized password if Excel asks for it.

5. Exit Protected View Safely

Use this when: Excel opens the file with a yellow or red security message because it came from the internet, email, or another potentially unsafe location.

Protected View is a security feature, not simply an annoying read-only setting. Microsoft recommends leaving the file in Protected View unless you know and trust its source and contents.

If the yellow Message Bar appears and you trust the file, select Enable Editing. If Excel displays a red warning, use File > Edit Anyway only after you have verified that the file is expected and trustworthy.

Security note: Avoid disabling all Protected View options globally just to make one workbook editable. Doing so reduces protection for future files from email, websites, and other untrusted locations. If your organization manages these settings, contact your administrator instead of bypassing the policy.

6. Fix a Workbook Locked for Editing

Use this when: Excel says the workbook is locked for editing by another user, or sometimes even by you.

This is not the same as a normal read-only attribute. Microsoft recommends first checking whether the workbook is open on another device or in another Excel session.

1. Close the workbook on your other devices and close any duplicate Excel windows.
2. Wait a few minutes if the file is stored on a server, OneDrive, or SharePoint so the lock has time to clear.
3. If another person is editing the workbook, wait for them to close it or request edit access.
4. For collaborative work, use a supported co-authoring version of Excel and store the workbook in OneDrive or SharePoint in Microsoft 365.
5. If you only have view permission, use Excel's access controls to request editing permission from the owner.

Part 3. What If Excel Still Opens the File Read-Only?

If none of the fixes above match what you see, do not assume the workbook is corrupted. Check these possibilities first:

• The workbook is stored in a location where you only have view permission. Save a copy to a folder where you have write access or request edit permission.
• The file is being synced. Make sure OneDrive or another approved sync service has finished syncing and is not paused.
• The workbook is open elsewhere. Close Excel on other computers, phones, virtual desktops, or remote sessions.
• An add-in is holding the workbook open. If the lock repeatedly returns, test Excel without nonessential add-ins.
• The file came from another person or organization. Ask the owner whether the workbook was intentionally protected or shared as view-only.

If your workbook displays the more specific message that Excel cannot access a file because it may be read-only or encrypted, the separate guide to Excel files that are read-only or encrypted covers that error in more detail.

Part 4. Repair the Excel File If It Is Actually Corrupted

A workbook being read-only does not, by itself, mean it needs repair. File repair becomes more relevant when Excel reports file corruption, unreadable content, invalid file format, damaged workbook structure, or the same local file fails to open correctly in multiple appropriate Excel environments.

If that is the problem, Repairit Excel File Repair is designed for damaged Excel workbooks. The broader Wondershare Repairit toolkit also supports other damaged document and media formats.

Key Features of Repairit File Repair

Wondershare Repairit - Excel File Repair

Try It Free

Try It Free

1,010,994 people have downloaded it.

• Repair damaged Excel files with all levels of corruption, including blank files, files not opening, unrecognizable format, unreadable content, files layout changed, etc.
• Repairs all kinds of data stored in damaged Excel files such as tables, charts, formulas, comments, images, etc.
• Support all formats of Excel files: XLSX/XLSM/XLTX/XLTM/XLS
• Perfectly repair corrupted files with a very high success rate, without modifying the original file.
• No limit to the number and size of the repairable files.
• Support Windows 11/10/8/7/Vista, Windows Server 2003/2008/2012/2016/2019/2022, and macOS 10.12~macOS 13.
• Except for Excel, Repairit also supports all formats of PDF, Word, Excel, PowerPoint, ZIP, and Adobe files.

Repair a Corrupted Excel File With Repairit

Use this workflow when the workbook itself is damaged, not merely because an editing restriction is active.

Step 1. Open File Repair. Launch Repairit and choose More Types Repair > File Repair.

Step 2. Add the corrupted Excel workbook and start the repair. Select + Add, import the affected file, and choose Repair.

Step 3. Preview and save the repaired workbook. Review the result and save the repaired file to a different location from the damaged source.

Conclusion

An Excel workbook can become read-only for several reasons, so the safest fix is the one that matches the restriction you actually see. Turn off Mark as Final when the file was finalized, remove Read-only Recommended when it was saved that way, clear the Windows file attribute when appropriate, use the correct password for workbook protection, and leave Protected View enabled unless you trust the file. If Excel says the workbook is locked by another user, resolve the collaboration or permission issue instead of changing unrelated security settings. Only move to file repair when the workbook itself shows genuine signs of corruption.