Last updated on November 17th, 2026 at 03:15 pm
Excel has several kinds of read-only, so start with the message under the ribbon. A workbook set to always open read-only needs Edit Anyway, then File > Info > Protect Workbook > Always Open Read-Only to turn it off; save and close afterward. A yellow Protected View bar needs Enable Editing. For a file marked read-only in Windows, right-click it, choose Properties, clear Read-only and select OK. Mac users get their own section below.
Why an Excel workbook opens as read-only
“Read-only” means you can open and look at the workbook, but Excel won’t let you save changes to that file. It is not one single setting. Excel and Windows have several separate features that all end up with the same result, and turning off one of them does nothing to the others. Here are the common causes, what you usually see, and where to fix each one:
| What you see | Likely cause | Where to fix it |
|---|---|---|
| A message asking you to open the file read-only, with an Edit Anyway option | The author set the workbook to always open read-only | Turn off Always Open Read-Only |
| A “Marked as Final” message at the top of the workbook | The author marked the workbook as final | Remove Mark as Final |
| A yellow or red bar labeled Protected View | The file came from the internet, an email attachment or another unsafe location | Exit Protected View |
| Read-only in the title bar, and no message bar at all | The file’s Read-only attribute is set in Windows, or the file is in use | Clear the Read-only attribute, or fix a locked file |
| A message that the file is locked for editing or in use | Another person, another device or a crashed session has the file open | Fix “locked for editing” |
| You can open the file, but some cells or sheets refuse changes | Sheet or workbook structure protection (not read-only) | Unprotect a sheet or workbook |
| Every workbook opens read-only, and Excel mentions an unlicensed product | Microsoft 365 or Office isn’t activated | Troubleshooting below |
If you only need your own editable version and don’t need to change the original, you can also save a copy with File > Save As in a folder where you’re allowed to save. That leaves the original untouched.
Turn off Always Open Read-Only in Excel for Windows
This is the setting most people mean when they ask how to change read-only mode. The workbook’s author turns it on to suggest that people read the file without changing it. Only the author can turn it off, and you can’t turn it off without selecting Edit Anyway first or while someone else has the file open.
- Open the workbook. When Excel shows the read-only message, select Edit Anyway. The workbook switches to editing, but the setting is still saved in the file.
- Select the File tab, then select Info. The Info page shows the workbook’s protection status.
- Select Protect Workbook. A list of protection options opens.
- Select Always Open Read-Only. This clears the setting, so the workbook no longer asks to open read-only.
- Save the workbook and close it. The next time you open it, it should open ready for editing, without the read-only message.

If Always Open Read-Only isn’t selected in that list, this setting isn’t the cause. Check the other sections below. The same steps appear on the Remove read only from a file support page.
Remove Mark as Final
Mark as Final is a courtesy label, not a lock. It tells people the workbook is finished and makes it read-only until someone chooses to edit it.
- Open the workbook. A “Marked as Final” message appears at the top.
- Select Edit Anyway on that message. This removes the read-only status, and you can start typing right away.
- Save the workbook so the change is kept.
If you’re the author and want to set or clear the label yourself, it’s under File > Info > Protect Workbook > Mark as Final. Because anyone can select Edit Anyway, don’t rely on Mark as Final to stop changes.
Exit Protected View
Protected View is a safety feature, not an error. Excel opens a file this way when it came from the internet, arrived as an Outlook attachment from a sender your computer treats as unsafe, sits in an unsafe location such as a temporary internet folder, is caught by File Block, fails Excel’s file validation check, or comes from someone else’s OneDrive. You can read the workbook, but editing is switched off until you decide you trust it.
- Look at the color of the bar under the ribbon.
- For a yellow bar, select Enable Editing if you trust where the file came from. The bar disappears and you can edit.
- For a red bar, Excel found a possible problem with the file. You can select File > Edit Anyway, but only if you’re sure the file is safe. If a file looks suspicious, close it and delete it.
Once you enable editing, Excel treats that file as a trusted document, so it won’t open in Protected View again. Word documents behave the same way, and enabling editing in Word covers the Word-specific locks such as Marked as Final. If the workbook also contains macros, Excel then shows a separate security bar, and this walkthrough on turning on macros in Excel for Microsoft 365 explains each one.
You can change which files open in Protected View at File > Options > Trust Center > Trust Center Settings > Protected View. The options cover files from the internet, files in potentially unsafe locations, Outlook attachments, and (in Excel only) untrusted text-based files like .csv and database files. Turning these off removes a layer of protection against harmful files, so check with your administrator first. For most people, selecting Enable Editing one file at a time is the better choice. The What is Protected View? support page goes into more detail.
Clear the Read-only attribute in Windows
Windows can mark the file itself as read-only, outside Excel. This often happens with files copied from somewhere else. When the attribute is set, Excel opens the workbook read-only every time, and no setting inside Excel changes that.
- Close the workbook in Excel.
- In File Explorer, find the file and right-click it.
- Select Properties. The file’s Properties window opens.
- Clear the Read-only check box.
- Select OK, then open the workbook again in Excel. It should now open for editing.
Only clear this box on files you own or are allowed to change. If the box won’t stay cleared, or Windows tells you that you need permission, your account may not have rights to change files in that folder (common on work networks). Ask the folder’s owner or your IT team, or save a copy somewhere you can write to.
If you’re comfortable with Command Prompt, the attrib command does the same job: attrib -r followed by the file name clears the Read-only attribute, as described in Microsoft’s attrib command reference.
Open a workbook that recommends read-only or asks for a password
Two other author settings show a prompt when the file opens:
- Read-only recommended. Excel asks whether you want to open the file read-only. This is only a suggestion. Choose to open it normally if you need to edit. The prompt does not prevent changes to the workbook.
- Password to modify. Excel asks for a password before you can edit. Without the password, you can’t save changes to the original. If Excel lets you open it read-only and you need your own working version, use File > Save As to save a copy under a new name. For the original file, ask the person who set the password.
To stop the read-only recommendation on a workbook you created, save it again with that option cleared. In Excel for Mac, it’s the Read-only recommended check box under File > Passwords. On Windows, the author can save the workbook again without the recommendation.
A password to open is a different feature. Excel encrypts the workbook, and you need that password to see anything at all. If you set the password and know it, you can remove it at File > Info > Protect Workbook > Encrypt with Password by deleting the password and selecting OK. Microsoft can’t recover a forgotten password, and password-cracking tools or upload-and-unlock websites are not a safe or appropriate route for files that aren’t yours. Contact the file’s owner instead.
Fix “locked for editing” and files in use
If Excel reports that the workbook is locked for editing or already in use, someone (possibly you) still has it open. Excel lets you open it read-only, but not edit it, until the lock is released. When several people need to save changes to one file on a network folder at the same time, look at Excel’s legacy shared workbook feature or co-authoring.
- You opened it somewhere else. Close the file on every device, wait a few minutes for the server to release the lock, and open it again. If Excel crashed earlier, restarting your computer clears a lock left behind by that session.
- Another person has it open. Wait until they close it, ask them to close it, or open it read-only for now. In a shared file, you can select Viewing, then Request more access, and choose Ask to edit. The owner gets an email to approve or decline.
- Someone is using a version without co-authoring. Co-authoring lets several people edit at once, but it needs Excel for Microsoft 365 or Excel for the web. Excel 2016, 2019 and 2021 LTSC don’t support it, and one person using such a version can lock the file for everyone.
- The file is stored in the wrong place for co-authoring. Co-authoring works for files in OneDrive, OneDrive for Business or SharePoint, not on network shares or other cloud services. Move the file there if several people need to edit together.
- The file uses an older format or blocking features. Save it as .xlsx, .xlsm or .xlsb with File > Save As > Browse > Save as type. Turn off the legacy Shared Workbook feature, and remember that password encryption also blocks co-authoring.
- OneDrive is out of date or paused. On Windows, update the OneDrive sync app and make sure syncing isn’t paused.
For shared files, make sure the person who shared it gave you edit rather than view access. Those permissions are chosen when someone is sharing an Excel sheet. The full checklist is on the Excel file is locked for editing support page.
Unprotect a sheet or the workbook structure
Sometimes a workbook isn’t read-only at all. You can open and save it, but certain cells, sheets or sheet tabs won’t change. That’s sheet or workbook protection, which is separate from read-only mode.
- Sheet protection locks cells on one worksheet. To remove it, go to the sheet, then select Review > Unprotect Sheet (in the Changes group), or File > Info > Protect > Unprotect Sheet. Enter the password if asked and select OK.
- Workbook structure protection stops you adding, deleting, renaming, moving, copying, hiding or unhiding sheets. To remove it, select Review > Protect Workbook, enter the password if asked, and select OK. When it’s on, the Protect Workbook button is highlighted.
Worksheet protection isn’t meant as a security feature, and Microsoft can’t retrieve a forgotten sheet password. If a colleague protected the sheet, ask them to unprotect it or to share the password.
Turn off read-only in Excel for Mac
On a Mac, the read-only switch is in the File menu rather than the Info page.
- Open the workbook in Excel for Mac.
- Open the File menu. If Always Open Read-Only has a check mark, select it to remove the check mark.
- To check for a read-only recommendation, select File > Passwords. In the File Passwords dialog box, clear Read-only recommended and select OK.
- Save and close the workbook, then open it again to confirm it opens for editing.
On a shared workbook, anyone with write access can clear this read-only status, so it’s a convenience rather than real protection. If the file itself is locked in the Finder, unlock it there first. The Mac steps are also on Set or clear read-only status in Excel for Mac.
How to check that read-only is off
- Excel no longer shows a read-only label or a message bar under the ribbon when the file opens.
- You can type in a cell and save the workbook without being asked to choose a new file name.
- After closing and reopening, the workbook still opens for editing. If the read-only state comes back, a second cause is still active, so work through the table at the top again.
Troubleshooting when Excel stays read-only
- Every workbook opens read-only. Check whether Excel shows an Unlicensed Product message or an activation error. When Microsoft 365 apps aren’t activated or the license has ended, they run in reduced functionality mode, where you can only view and print documents. Sign in with the account that has your subscription to reactivate. Connecting to the internet also helps if the computer has been offline for more than 30 days.
- Files saved in OneDrive won’t save. Your OneDrive storage may be full. Select the OneDrive icon in the notification area and choose Manage storage to check your space, then free some up.
- Antivirus opens files read-only. Some antivirus programs open Office files read-only to protect you. Check your antivirus settings or ask your IT team.
- Protect Workbook options are missing or greyed out. You may still be in read-only or Protected View. Select Edit Anyway or Enable Editing first. On work or school computers, an administrator can also control Protected View and other Trust Center settings.
- You don’t have permission. On shared drives, SharePoint or files shared with you, only the owner or an administrator can give you edit access. Ask for edit permission rather than trying to work around it.
- Nothing else works. Restart your computer, install Office updates, run an Online Repair of Office, and check your internet connection. These steps are listed on the Why did my file open read-only? page.
Related guides

Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people’s computers. Each guide follows Microsoft, Apple and Google’s own documentation and is updated when the steps change. Screenshots marked “Recreated” are illustrations of the real screens.