What to do when an Excel file won't open because it's password protected

An Excel file locked with a password will not open until you enter the correct password. If you have the password, you can unlock it in seconds. If you don't have it, your options depend on whether the file is locked to prevent opening, locked to prevent editing, or locked to prevent changes to specific cells.

The steps differ slightly between Excel on Windows, Excel on Mac, and Google Sheets. This guide covers all three, plus what to do if you've forgotten the password entirely.

Key Takeaways

  • A password-protected Excel file requires the correct password to open or edit, depending on what type of protection was applied.
  • If you have the password, you can unlock the file by entering it when prompted or through the Tools menu in Google Sheets.
  • Removing password protection without the password is difficult and may not be possible depending on the encryption method used.
  • Some third-party tools claim to remove Excel passwords, but they work only on older file formats and carry security risks.
  • The fastest solution is to contact whoever locked the file and ask them for the password.

Unlocking an Excel file on Windows when you have the password

When you open a password-protected Excel file on Windows, a dialog box appears asking for the password. Type the password exactly as it was set — passwords are case-sensitive, so "Password" is different from "password". Click OK.

If the file opens but you cannot edit it, the file is locked for editing only, not for opening. Go to the Review tab at the top of the screen. Look for a button labeled "Unprotect Sheet" or "Unprotect Workbook" depending on what is locked. Click it and enter the password again.

If you see a message that says the file is "read-only," this is different from password protection. Right-click the file in Windows Explorer, select Properties, and uncheck the box next to "Read-only" at the bottom of the window. Click Apply and OK.

Unlocking an Excel file on Mac when you have the password

On Mac, the process is nearly identical. When you open the file, enter the password in the dialog that appears. If the file opens but you cannot edit it, click the Review tab, then look for "Unprotect Sheet" or "Unprotect Workbook" and enter the password again.

If you see a message that the file is locked because another user has it open, close the file completely and try again. Make sure no other copy of the file is open on your computer or on iCloud.

Unlocking an Excel file in Google Sheets

If the file is stored in Google Drive and you open it with Google Sheets, the process is different. Google Sheets does not support password-protected files in the same way Excel does. If you try to open a password-protected Excel file in Google Sheets, you will be prompted for the password. Enter it and the file will convert to Google Sheets format.

Once the file is in Google Sheets, you can share it or change permissions, but you cannot add password protection the way Excel does. If you need to keep the file in Excel format with password protection, download it back to your computer and open it with Excel instead.

What to do if you've forgotten the password

If you do not have the password and cannot contact the person who set it, your options are limited. For files in the newer Excel format (.xlsx), password protection uses strong encryption that is very difficult to break without the password.

Some third-party tools claim to remove Excel passwords, but most work only on older file formats (.xls) and are not reliable. These tools also carry security risks because they come from outside Microsoft and may contain malware. Before using any third-party tool, back up your file in case something goes wrong.

The most practical solution is to ask the file owner for the password. If the file is work-related, contact your manager or IT department. If it is personal, reach out to whoever sent it to you.

Understanding the difference between opening passwords and editing passwords

Excel allows two types of password protection. An opening password prevents anyone from opening the file at all without the correct password. An editing password allows the file to open, but prevents changes unless the password is entered.

If a file has an opening password, you will see a prompt the moment you try to open it. If it has only an editing password, the file opens normally, but you cannot change anything until you remove the protection through the Review tab.

Some files have both types of protection. In that case, you need the opening password to view the file and the editing password to make changes. These are usually different passwords.

Protecting your own Excel files with a password

If you want to lock a file you own, open it in Excel and go to the File menu. Select "Info," then look for "Protect Workbook" or "Protect Sheet" depending on what you want to lock. Choose "Encrypt with Password" to set an opening password, or "Protect Current Sheet" to allow opening but prevent editing.

Write down the password somewhere safe. If you forget it, you will have the same problem as anyone else trying to open a locked file without the password. There is no "forgot password" recovery option in Excel.

Frequently Asked Questions

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

Not reliably. Modern Excel files use encryption that is designed to be unbreakable without the correct password. Older .xls files can sometimes be cracked with third-party tools, but this is slow and not may provide to work. Your best option is to contact whoever locked the file.

What if the file is corrupted and won't open even with the correct password?

Try opening the file in a different program. Google Sheets, LibreOffice, or an older version of Excel sometimes can open corrupted files that the current version cannot. If none of these work, the file may be permanently damaged and unrecoverable.

Does Excel password protection work on files shared through OneDrive or SharePoint?

Yes, password protection applies to the file itself, not to where it is stored. A password-protected file will require the password whether it is on your computer, OneDrive, SharePoint, or Google Drive. The password is part of the file, not part of the sharing settings.

Can I unlock an Excel file if I have administrator access to my computer?

No. Administrator access to your computer does not give you access to files encrypted with a password. The encryption is built into the file itself, not controlled by your operating system or user account.

What happens if I enter the wrong password too many times?

Excel does not lock you out after multiple wrong attempts. You can keep trying different passwords indefinitely. However, if you are guessing, this will take a very long time for any password longer than a few characters.