Excel won’t let you password protect because the file is likely in a format that doesn’t support encryption, you’re trying to protect a workbook or worksheet (which is different from file-level password protection), or you’re using an older file type like .xls. The direct fix is to save the file as .xlsx (or .xlsm if it contains macros) and use File > Info > Protect Workbook > Encrypt with Password for a true file-open password. For worksheet or workbook protection, use Review > Protect Sheet or Protect Workbook.
Why Excel Password Protection Fails
Excel has several distinct protection features, and confusing them is the most common reason “it won’t work.” The three main types are:
- File-level encryption – requires a password to open the file at all. This is the only true “password protect” that prevents unauthorized access.
- Worksheet protection – prevents users from editing specific cells, but the file can still be opened without a password.
- Workbook protection – prevents adding, moving, or deleting sheets, but again, the file opens freely.
If you try to set a password to open a file that is saved in the legacy .xls format, Excel may disable the option because the old format uses weaker encryption that Microsoft no longer supports by default. Similarly, if you’re using Excel for the web, password protection is not available at all—you can only use the desktop version.
How to Set a Password to Open a File
To require a password to open an Excel file, follow these steps in Excel for Microsoft 365 on Windows:
- Click File > Info.
- Click Protect Workbook (or the Protect Workbook dropdown).
- Select Encrypt with Password.
- Type a password in the dialog box, then click OK.
- Re-enter the password to confirm, then click OK.
- Save the file (Ctrl+S).
On a Mac, the path is File > Passwords, then check “Password to open” and enter the password. In Excel for the web, this feature is absent—you must use the desktop app.
Important: If you forget the password, there is no way to recover it. Excel uses AES-256 encryption by default, and Microsoft cannot retrieve your password. Always store passwords in a password manager.
Protecting a Worksheet vs. the Whole File
If you only want to prevent others from changing formulas or data in specific cells, you need worksheet protection, not file encryption. Here’s how:
- Select the cells you want users to be able to edit (if any).
- Right-click the selected cells and choose Format Cells.
- Go to the Protection tab, uncheck Locked, and click OK. (By default, all cells are locked, but this only takes effect when you protect the sheet.)
- Go to Review > Protect Sheet.
- Enter a password (optional), choose what users can do (e.g., select locked cells, format rows), and click OK.
On a Mac, the steps are identical. In Excel for the web, you can protect a sheet but not with a password—it uses a simple on/off switch.
Workbook protection (Review > Protect Workbook) prevents users from adding, deleting, or renaming sheets. It’s a separate feature and does not require a password to open the file.
Common Problems and Solutions
Here are the typical reasons you might see “Excel won’t let me password protect” and how to fix them:
- File is in .xls or .xltx format: Go to File > Save As, choose .xlsx (or .xlsm for macros), then try Encrypt with Password again.
- You’re using Excel for the web: Switch to the desktop app (Windows or Mac) to set a password.
- You’re trying to protect a shared workbook: If the workbook is shared (Review > Share Workbook), encryption is disabled. Unshare it first.
- The option is greyed out: This can happen if the file is in compatibility mode or if you don’t have permission to modify it (e.g., the file is read-only). Save a copy with a new name.
- You set a password but it doesn’t ask when opening: You might have set worksheet protection instead of file encryption. Check File > Info > Protect Workbook – it should say “A password is required to open this workbook.”
How to Choose the Right Protection
Decide what you actually need:
- Keep the entire file private → Use Encrypt with Password (File > Info > Protect Workbook).
- Allow viewing but prevent editing of certain cells → Use Protect Sheet (Review > Protect Sheet).
- Prevent structural changes like deleting sheets → Use Protect Workbook (Review > Protect Workbook).
- Allow multiple users to edit but track changes → Use Share Workbook (Review > Share Workbook) – note this disables encryption.
For sensitive data, always use file encryption. Worksheet protection is not secure—it’s meant to prevent accidental edits, not malicious access. A knowledgeable user can unprotect a sheet by copying the data or using a macro.
Password Strength and Security Considerations
Excel’s encryption uses AES-256, which is strong, but the password itself is the weakest link. Use a password that is at least 12 characters long, with a mix of uppercase, lowercase, numbers, and symbols. Avoid using the same password you use for email or banking.
Be aware that password protection only protects the file at rest. If you send the file over email, the password is not encrypted in transit unless you use a secure method. Also, if you share the password with others, they can share it further.
There is no backdoor. If you lose the password, you lose access. Microsoft’s official stance is that they cannot recover passwords. Some third-party tools claim to recover Excel passwords, but they are often unreliable or malicious. The only safe approach is to keep a backup of the password in a password manager.
Alternatives to Password Protection
If you find Excel’s built-in protection insufficient or you’re using Excel for the web, consider these alternatives:
- Save as PDF – If you only need to share a read-only view, export to PDF and optionally set a PDF open password (using a separate tool).
- Use a cloud service with permissions – Store the file in OneDrive or SharePoint and set sharing permissions to “Can view” or “Can edit” for specific people. This doesn’t require a password.
- Use a third-party encryption tool – Tools like 7-Zip can create a password-protected archive containing the Excel file. This works with any file type and is often more flexible.
- Digital signatures – For integrity, you can add a digital signature to ensure the file hasn’t been tampered with, but this doesn’t prevent opening.
For most home users, Encrypt with Password is sufficient. For business or highly sensitive data, consider using a dedicated file encryption tool or a secure cloud service with multi-factor authentication.
Frequently Asked Questions
Why is the “Encrypt with Password” option greyed out?
This usually happens when the file is in an older format (.xls), is a shared workbook, or is protected with a digital signature. Save the file as .xlsx first, unshare it (Review > Share Workbook > uncheck “Use the old shared workbooks feature”), and remove any digital signatures (File > Info > View Signatures). Then try again.
Can I password protect a single sheet without protecting the whole file?
Yes, you can protect a single worksheet using Review > Protect Sheet. This allows users to open the file and view all sheets, but they can’t edit the protected sheet’s locked cells unless they know the password. However, the sheet’s data is still visible, so it’s not for hiding data.
Does Excel for the web support password protection?
No. Excel for the web does not support file-level password encryption. You can only protect a worksheet (without a password) or use OneDrive sharing permissions. To set a password, open the file in the desktop Excel app.
What’s the difference between “Protect Workbook” and “Encrypt with Password”?
“Protect Workbook” (under Review) prevents users from adding, moving, or deleting sheets, but the file can be opened without a password. “Encrypt with Password” (under File > Info) requires a password to open the file at all. They serve different purposes; you can use both simultaneously.
I forgot my Excel password. Can I recover it?
No. Microsoft does not provide a password recovery service, and there is no built-in backdoor. Some third-party tools claim to recover passwords, but they are often ineffective or risky. The only reliable way is to use a password manager to store your passwords.
Is worksheet protection secure?
No. Worksheet protection is designed to prevent accidental edits, not malicious attacks. A determined user can unprotect a sheet by copying the data or using a simple VBA macro. For real security, use file-level encryption.
Related
- Excel Budget Calendar Template: How to Build One
- Excel Sum Only Numbers Ignore Text in Cell?
- Excel Sum Showing Zero? Fixes That Work
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Page Breaks in Excel Won’t Go Away? How to Fix ThemIf page-break lines in Excel won’t go away, switch to View > Normal to leave Page Break Preview,…
- XLOOKUP Formula Not Working? Fix Common ErrorsIf your XLOOKUP formula is not working, first check that your Excel version supports XLOOKUP, that the lookup…
- Excel CONCAT to Remove a File Name SuffixCONCAT in Excel joins text; it does not remove a file-name suffix by itself. To remove the last…
- Why Is the Dollar Sign Not Working in Excel Formulas?The dollar sign in Excel has two common jobs: it can display a number as currency, or it…
- XLOOKUP Excel Not Working? Fix Common Errors and CausesIf XLOOKUP is not working, first check that your Excel version supports it, then confirm the lookup and…
- Array Formula Excel Not Working? Common FixesIf an Excel array formula is not working, first check whether it needs to spill into empty cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.