What "locked" means for an Excel file

An Excel file (.xls or .xlsx) is locked when someone has set a password on it. This password prevents you from opening the file, editing it, or sometimes both — depending on how the protection was set up. The file itself is not damaged or corrupted; it straightforward will not open or let you make changes without the correct password.

The person who locked it may have done this to prevent accidental changes, keep sensitive data private, or control who can view the spreadsheet. If you are the one who set the password and forgot it, or if someone sent you a locked file and gave you the password separately, you will need that password to proceed.

Key Takeaways

  • A locked Excel file requires a password to open or edit, and you cannot bypass this without the correct password.
  • If you have the password, you enter it when you first try to open the file in Excel, and the file opens normally afterward.
  • If you forgot the password or never received it, contact the person who locked the file — they are the only one who can remove the protection.
  • Some files have sheet-level protection (you can open the file but cannot edit certain sheets), which is different from file-level protection.
  • There is no legitimate way to remove password protection without the password; tools claiming to do so are unreliable or unsafe.

Opening a locked file when you have the password

When you try to open a password-protected Excel file, a dialog box appears asking for the password. Type the password exactly as it was set — passwords are case-sensitive, meaning uppercase and lowercase letters are treated as different characters. Click OK or press Enter.

If the password is correct, the file opens and you can view and edit it normally. The file remains password-protected; the next time someone tries to open it, they will be asked for the password again. You do not need to enter the password every time you work on the file during the same session — only when you first open it.

Recovering a password you forgot

If you set the password yourself and have now forgotten it, contact the person or organization that manages your account recovery. For Microsoft 365 accounts, you can reset your password through your Microsoft account settings, though this does not directly unlock the file — it allows you to access your account and any password hints you may have stored there.

If the file was locked by someone else and you do not have the password, you must ask that person for it. They can either give you the password or remove the protection themselves and send you an unlocked version. There is no other legitimate path forward; any online tool or software claiming to crack Excel passwords is either ineffective or poses a security risk to your computer.

Sheet-level protection versus file-level protection

Excel offers two different types of password protection, and they work differently. File-level protection prevents you from opening the file at all without the password. Sheet-level protection lets you open the file, but prevents you from editing specific sheets or cells within it.

If you can open the file but certain cells or sheets are locked and you cannot edit them, the file has sheet-level protection. You will see a message like "The sheet is protected" when you try to make changes. The person who protected the sheet can remove this protection through the Tools or Review menu (depending on your Excel version) by entering the password.

Removing protection when you are the owner

If you locked the file yourself and still remember the password, you can remove the protection. In Excel, go to the Tools menu (Mac) or the Review tab (Windows), then select Unprotect Sheet or Unprotect Workbook. Enter the password when prompted, and the protection is removed. The file is now unlocked and anyone can open and edit it.

Once you remove protection, the password is gone — you cannot recover it later if you change your mind. If you want to re-protect the file, you will need to set a new password.

Why a file might appear locked but is not

Sometimes a file seems locked when the real problem is something else. If you see an error message about the file being read-only, the issue is usually file permissions on your computer, not a password. Right-click the file, select Properties (Windows) or Get Info (Mac), and check whether the file is marked as read-only. If it is, uncheck that box and try opening it again.

Another common confusion: if the file opens but shows "Protected View" at the top, Excel is being cautious because the file came from the internet or an untrusted source. This is not a password lock. Click "Enable Editing" to proceed, and the file will work normally.

Frequently Asked Questions

Can I open a locked Excel file without the password?

No. Password protection on Excel files is designed to prevent unauthorized access, and there is no legitimate way to bypass it. If you do not have the password, you must contact the person who set it.

What if I have the file but the person who locked it is no longer available?

If the file is critical to your work, contact your IT department or manager — they may have records of who set the password or may be able to help you recover the data another way. For personal files, unfortunately, the data is not recoverable without the password.

Is the password the same every time I open the file?

Yes. Once a password is set on a file, that same password is required every time anyone opens it, until the protection is removed. You do not need to re-enter it during the same work session, only when you close and reopen the file.

Can I copy data from a locked file without opening it?

No. A password-protected file cannot be opened, viewed, or copied from without the password. The protection applies to the entire file.

Does password protection slow down Excel or cause other problems?

No. Password protection does not affect how the file performs or how Excel runs. It only controls access when the file is opened.