The fastest way to unlock a read-only Excel file

If Excel opens your spreadsheet in read-only mode, the file is locked against editing. You can unlock it in most cases by saving a copy under a new name, checking the file properties for a read-only flag, or removing password protection if one exists. The method depends on why the file became read-only in the first place.

Read-only mode usually happens for one of four reasons: the file itself is marked read-only in Windows, the file is stored on a read-only location like a shared network drive, someone password-protected it, or Excel opened it in safe mode because it detected a problem. Each has a different fix.

Key Takeaways

  • Save the file as a copy with a new name — this removes read-only status in most cases and is the fastest method.
  • Right-click the file in Windows File Explorer, select Properties, and uncheck the Read-only box if it is marked.
  • If the file is password-protected, you must enter the password in the Unprotect Sheet or Unprotect Workbook dialog to remove the lock.
  • Files stored on shared network drives or cloud storage may open read-only if you do not have write permission — contact the file owner or your IT department to change your access level.
  • If Excel shows a yellow notification bar saying the file opened in protected view, click Enable Editing to switch to normal mode.

Save the file as a copy to remove read-only status

The simplest method is to save the spreadsheet under a new filename. Open the file in Excel, go to File menu, and select Save As. Choose a new location and filename, then click Save. The new copy will not carry the read-only restriction.

This method works because read-only status is tied to the original file, not to the data inside it. When you save as a new file, Excel creates a fresh copy without the lock. You can then delete the original read-only version if you no longer need it.

Uncheck the read-only flag in file properties

Windows can mark a file as read-only at the operating system level. To check this, close Excel, then right-click the spreadsheet file in File Explorer. Select Properties from the menu. In the General tab, look for a checkbox labeled Read-only near the bottom of the window.

If the box is checked, click it to uncheck it, then click explore and OK. Open the file in Excel again — it should now allow editing. If the checkbox is grayed out and you cannot uncheck it, the file may be stored on a network drive where you lack write permission, or your user account does not have permission to change file properties.

Remove password protection from the sheet or workbook

If someone password-protected the spreadsheet, Excel will show a notification bar at the top saying the sheet is protected. To unprotect it, go to the Review tab in the ribbon. Look for a button labeled Unprotect Sheet or Unprotect Workbook, depending on what is locked. Click it and enter the password when prompted.

If you do not know the password, you cannot remove the protection through Excel's built-in tools. You would need to contact whoever set the password. Some third-party tools claim to remove Excel passwords, but they are unreliable and may damage the file.

Enable editing if Excel opened the file in protected view

Excel sometimes opens files in protected view — a restricted mode that prevents editing — if the file came from the internet or an untrusted location. You will see a yellow notification bar below the ribbon that says something like "This file opened in protected view. Click Enable Editing to edit this workbook."

Click the Enable Editing button on that bar. The file will switch to normal editing mode. If you trust the source of the file, you can also right-click the file in File Explorer, select Properties, and check a box labeled Unblock at the bottom of the General tab. This tells Windows the file is safe, and Excel will not open it in protected view again.

Check permissions if the file is on a shared drive

Files stored on network drives, shared folders, or cloud storage services like OneDrive or SharePoint may open read-only if your user account does not have write permission. You will usually see a notification in Excel saying you have read-only access.

Contact the person who owns the file or your IT department and ask them to give you edit permission. They can change your access level in the sharing settings. Once they do, close and reopen the file in Excel — you should now be able to edit it. If the file is on your own OneDrive or Google Drive, check the sharing settings yourself to make sure your account has editor access, not just viewer access.

What to do if none of these methods work

If the file still opens read-only after trying these steps, the most reliable solution is to copy all the data into a new blank spreadsheet. Open a fresh Excel file, then copy the contents from the read-only file and paste them into the new one. Save the new file with your desired name.

This method works because you are creating a completely new file from scratch. The read-only restriction stays with the original file and does not transfer to the new one. You lose any formatting, formulas, or macros that were embedded in the original, so this is a last resort — but it will let you work with the data.

Frequently Asked Questions

Why does Excel keep opening my file in read-only mode?

The most common reason is that the file is marked read-only in Windows properties, or you do not have write permission to the folder where it is stored. Less often, the file is password-protected or Excel opened it in protected view because it came from an untrusted source. Check the notification bar at the top of Excel first — it usually tells you why the file is locked.

Can I edit a read-only Excel file without saving it?

No. Excel will not let you make permanent changes to a read-only file. You can view it and make temporary edits during your session, but when you close the file, those changes are lost. You must unlock the file or save a copy if you want to keep your edits.

If I save a copy of a read-only file, will the copy also be read-only?

No. When you use Save As to create a new file, the copy will have normal edit permissions. The original read-only file stays locked, but the new copy is fully editable.

What does "protected view" mean in Excel?

Protected view is a restricted mode Excel uses for files from untrusted sources — usually files downloaded from the internet or email attachments. In protected view, you can read the file but cannot edit it. Click Enable Editing in the yellow notification bar to switch to normal mode if you trust the file.

How do I know if a file is password-protected?

If the sheet is password-protected, the Review tab in the ribbon will show an Unprotect Sheet button instead of a Protect Sheet button. If the entire workbook is protected, you will see an Unprotect Workbook button. If neither button appears, the file is not password-protected.