Why Is Password Protection Not Working in Excel?

Errors & fixes · Updated November 20, 2026

Password protection often seems broken because Excel has several different protections: encrypting a file, locking a worksheet, and protecting workbook structure. First identify which one you set, then check the matching password and whether you are using the desktop app; a password for one kind of protection does not unlock the others.

Excel has more than one kind of password protection

The phrase “password-protect a workbook” can mean different things. This is the most important distinction to make when troubleshooting:

  • Password to open: Encrypts the file so Excel asks for a password before showing its contents. In Excel for Microsoft 365 on Windows, set it through File > Info > Protect Workbook > Encrypt with Password. This is the option to use when the goal is to prevent unauthorized people from opening the file.
  • Worksheet protection: Prevents changes to protected cells or certain worksheet features, but does not conceal the sheet’s contents. Use Review > Protect Sheet to set it.
  • Workbook structure protection: Restricts actions such as adding, deleting, moving, hiding, or renaming sheets. Use Review > Protect Workbook and protect the workbook structure.

These protections are independent. For example, a worksheet password will not satisfy a prompt that appears when opening an encrypted file. Similarly, encrypting a file does not automatically stop someone who can open it from changing cells. A common reason protection “does not work” is that the wrong feature was applied for the intended job.

Check that you applied the protection you intended

If you want Excel to request a password before displaying any data, use file encryption, not Protect Sheet. After entering a password in the Encrypt with Password dialog, save the workbook. Close it and reopen the saved file to confirm that the password prompt appears. If the prompt does not appear, check that you saved the same file you later reopened; similarly named copies in Downloads, OneDrive, or email attachments are easy to confuse.

If you only want to prevent accidental editing, select Review > Protect Sheet. Excel can protect cells, objects, and worksheet scenarios, and the dialog lets you choose which actions remain available. By default, cells are typically marked as locked, but that setting does not take effect until sheet protection is turned on. If you want some cells editable, select those cells, open Format Cells > Protection, clear Locked, and then protect the sheet. Otherwise, the result may not match your expectation.

To protect sheet names and arrangement, choose Review > Protect Workbook and select the structure option. If the intended restriction is specifically to stop users changing formulas or values, workbook structure protection is not the right control.

When Excel rejects a password

Excel passwords are case-sensitive. A capital letter, a different keyboard layout, or an accidental space at the beginning or end can make a familiar password fail. Type it carefully rather than relying on an autofill entry, and check whether Caps Lock or an input-language setting is affecting what you enter. If a password was copied from a password manager, check for an unintended trailing space.

Also confirm that you are entering the password for the correct prompt. A file may have a password to open and a separate password to modify, or it may have different passwords for sheet protection and workbook structure. If Excel accepts a password but then displays another prompt or leaves editing restricted, that does not necessarily mean the first password was rejected; it may be asking for a different permission.

For an encrypted file, make sure you have the latest saved copy. A password set on one copy will not automatically protect another copy created earlier. For files stored in a shared folder, ask the owner whether the password changed or whether you have the current version. Avoid repeatedly guessing: Excel does not provide a universal password that unlocks files, and repeated guesses do not identify which protection type the owner used.

Password accepted, but editing is still blocked

Sometimes the password is not the problem. If Excel opens the file but you cannot edit it, look for a banner saying Protected View, a read-only notice, or an editing restriction. Protected View is a safety feature for files Excel considers potentially risky, such as some files downloaded from the internet. Only choose Enable Editing when you trust the file and its source; doing so is separate from removing a worksheet password.

Check whether the file is marked read-only, opened from an email attachment, or locked for editing by another user. Also check the file’s permissions in OneDrive, SharePoint, or the folder where it is stored. Someone may have permission to view a file but not edit it, regardless of any sheet password. In a shared workbook, an organization’s access policy can prevent changes even when Excel itself has no sheet-protection prompt.

If only particular cells are unavailable, the sheet may be protected while other cells remain editable. If you need to change protected content, use Review > Unprotect Sheet and enter the sheet password when prompted. If the file is merely read-only, use the appropriate edit-permission or file-access route instead; removing sheet protection will not grant permission to edit a read-only file.

Saving, file formats, and shared copies

Protection may appear to vanish when a person saves or shares a different copy from the one they protected. Verify the file name and location in Excel’s title bar, and use File > Save As only when you understand which copy will be distributed. After adding or changing a password, save, close, and reopen the exact saved file as a practical check.

Use a current Excel workbook format such as .xlsx for a workbook without macros or .xlsm if it contains VBA macros. Older .xls files and files converted by other spreadsheet programs can behave differently, and some protection features may not transfer as expected. If a workbook has passed through another application, reopen and inspect it in desktop Excel, then save a new copy in the suitable Excel format. Do not assume that a visible lock icon or a message from another program confirms that Excel file encryption is active.

For files stored on OneDrive or SharePoint, distinguish a password from a sharing permission. A link can be restricted to named people, or an organization can require sign-in, without a workbook-open password. Conversely, an encrypted workbook can still be shared with someone who knows its password. If the concern is who can access a cloud file, review sharing permissions as well as workbook protection.

Excel for the web and Mac can behave differently

These instructions primarily describe Excel for Microsoft 365 on Windows. Excel for the web does not provide the same desktop controls for adding, changing, or removing file-level password encryption. If you need to manage an open-password setting, download or open the workbook in the desktop app. A password-encrypted workbook may require desktop Excel rather than the browser, so do not use the web version alone to diagnose an encryption prompt.

Excel for Mac has worksheet protection features, but the exact location and wording for file passwords can differ by build. In many current Mac versions, file password settings are available from File > Passwords; worksheet protection is on the Review tab. If you do not see the Windows path, check the Mac version’s File and Review menus rather than assuming that the feature is absent. The web app, desktop Windows app, and Mac app are not interchangeable for every protection task.

Protection is not a substitute for secure sharing

Worksheet and workbook-structure protection are mainly controls against accidental or routine changes. Microsoft does not present worksheet protection as a way to secure confidential data. A person who can open the workbook can see its contents, so hiding a worksheet or locking cells is not equivalent to encrypting the file.

Use file encryption when the requirement is to restrict opening, and use cloud or organizational access controls when the requirement is to limit who can obtain the file. For sensitive business information, follow your organization’s approved storage and sharing rules. Choose a unique password and share it through a separate, appropriate channel rather than placing it beside the workbook. A strong password cannot protect a file if the file and password are both sent openly to the same unintended recipient.

What to do if the password is lost

Excel does not provide a general-purpose way to display or recover a forgotten password for an encrypted workbook. For worksheet or structure protection, Microsoft likewise does not offer a universal password that works on every file. If you do not know the password, contact the person who created or manages the workbook and check for an authorized unprotected copy, backup, or previous version. In a workplace, an IT administrator may be able to help locate a permitted backup, but that does not mean they can reveal an unknown password.

Be cautious with online “unlock” services or tools that ask you to upload a workbook. The file may contain private or business data, and uploading it can create a separate confidentiality risk. Make a copy before trying any permitted recovery process, and do not replace the only original. If the file is encrypted and no authorized password or accessible backup exists, recovery may not be possible.

Frequently Asked Questions

Why does Excel let me open the file but not edit it?
It may be read-only, open in Protected View, restricted by sharing permissions, or have a protected worksheet. Check the banner and file permissions first, then use Review > Unprotect Sheet if a worksheet password is the specific restriction.

Why does Protect Sheet not ask for a password?
The password field in the Protect Sheet dialog is optional. If no password was set, Excel can turn protection off without asking for one. Protect Sheet still controls the options selected in the dialog, but it is not file encryption.

Can I password-protect an Excel file in a browser?
Use desktop Excel to add, change, or remove a password that encrypts a workbook for opening. Excel for the web has different capabilities, so open the file in the desktop app for that task.

Does hiding a worksheet protect its information?
No. Hiding a sheet changes what is immediately visible, and workbook structure protection can restrict unhiding it through normal Excel commands, but neither is a substitute for encrypting a file that contains confidential information.

Can Microsoft recover a forgotten Excel password?
There is no universal Microsoft recovery password for an encrypted workbook or protected sheet. Ask the file owner, look for a backup or prior version, and avoid uploading sensitive workbooks to untrusted recovery sites.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.