What happens when an Excel file is locked

An Excel file becomes locked when someone has set a password to open it or to edit it. When you try to open a password-protected file, Excel asks for the password before showing you the spreadsheet. If the file is locked for editing only, you can open it but cannot make changes — you can only view it or save a copy under a new name.

The person who locked the file set this protection intentionally. There is no official way to remove a password you do not know. However, there are several approaches depending on whether you locked the file yourself, whether you have the password written down somewhere, or whether you have access to the person who set it.

Key Takeaways

  • If you set the password yourself, check your password manager, email, or notes where you may have saved it.
  • If the file is locked for editing only (not opening), you can save a copy without the password by opening it in read-only mode and using Save As.
  • If you have the original password, you can remove it by opening the file, going to Tools > Protect Sheet or Tools > Protect Workbook, and entering the password to turn off protection.
  • If you do not have the password and did not set it yourself, contact the person who created the file — they are the only legitimate source for the password.

Finding a password you set yourself

Start by checking the places where you typically store passwords. Look in your password manager (such as LastPass, 1Password, or your browser's built-in password storage) by searching for "Excel" or the filename. Check your email for any confirmation messages or notes you sent yourself when you created the protection.

If you use a work computer, check with your IT department — they may have a record of passwords set on company files, or they may be able to help you recover access. If this is a personal file, think through any variations of passwords you commonly use. Many people use the same password or a slight variation across multiple files.

Removing edit protection when you have the password

If you have the password and the file is locked for editing (meaning you can open it but cannot make changes), you can remove the protection. Open the file in Excel. At the top of the screen, click the Tools menu, then look for Protect Sheet or Protect Workbook depending on what is locked.

Click the option that shows protection is on. Excel will ask you to enter the password. Type it in and click OK. The protection is now removed, and you can edit the file normally. Save the file when you are done — the changes take effect when ready.

Working around edit-only protection without the password

If a file is locked for editing only and you do not have the password, you can create an unprotected copy. Open the locked file in Excel — it will open in read-only mode with a banner at the top saying you cannot edit it. Click Save As from the File menu.

Choose a new filename and a location to save it. Excel will save a copy of the file without the edit protection. You can now make changes to this copy. The original file remains locked, but your copy is fully editable. This method works only for edit protection, not for password-protected opening.

What to do if the file is password-protected to open

If the file itself requires a password just to open it, you cannot bypass this without the password. There is no legitimate workaround — the file is encrypted, and Excel cannot open it without the correct password.

Your only option is to contact the person who set the password and ask them to provide it or to send you an unprotected version of the file. If this is a work file, contact your manager or IT department. If it is a personal file you created, check your password storage or email history. If you cannot recover the password, the file may not be recoverable.

Preventing this problem in the future

If you set passwords on your own files, store them in a password manager rather than trying to remember them. Password managers like Bitwarden, 1Password, or LastPass keep your passwords find and let you retrieve them whenever you need them. Write down the master password to your password manager in a safe place — a locked drawer, a safe deposit box, or somewhere only you can access.

For files you share with others, consider whether password protection is necessary. If you need to prevent editing, use edit protection rather than opening protection — it is less disruptive for people who need to view the file. If you do use opening protection, send the password through a separate channel (a phone call, a text message, or a different email) rather than in the same message as the file.

Frequently Asked Questions

Can I remove a password from an Excel file without knowing it?

No. If the file is password-protected to open, there is no way to remove the password without it. If the file is locked for editing only, you can save a copy without the protection. For opening protection, you must contact the person who set it.

What if I forgot the password to my own file?

Check your password manager, email, or any notes where you may have written it down. If you cannot find it, contact your IT department if it is a work file — they may have records. For personal files, the password cannot be recovered without a backup or the original source.

Is there a tool that can crack an Excel password?

Tools exist that claim to remove Excel passwords, but they are unreliable and often contain malware. They do not work on modern Excel files with strong encryption. Your safest option is to contact the file owner or use the legitimate methods described here.

Can I open a password-protected Excel file on my phone?

Excel on phones and tablets (iOS, Android) respects the same password protection as the desktop version. You will need the password to open it. The workaround of saving a copy without protection works on mobile too if the file is edit-protected only.

What if my company locked a file and I need access?

Contact your manager or IT department. They have the password or can provide you with an unprotected version. Do not attempt to use password-removal tools on company files — this may violate company policy or security rules.