If the Encrypt with Password option in Excel is greyed out, it is almost always because the workbook is in a shared or legacy compatibility mode that does not support file-level encryption. The fix is to turn off Shared Workbook (Review > Share Workbook) or save the file in the modern .xlsx format instead of .xls. Once you do that, the option becomes available again.
Why Is Encrypt with Password Greyed Out?
Excel disables Encrypt with Password (File > Info > Protect Workbook) when the file is in a state that conflicts with encryption. The most common causes are:
- Shared Workbook mode – When you enable Share Workbook (Review > Share Workbook), Excel turns off encryption because multiple users need simultaneous access without a single password.
- Legacy .xls format – The old Excel 97-2003 format has a weaker encryption model, and some newer encryption options are not available. Excel may grey out the option until you convert to .xlsx.
- Workbook is open as read-only – If the file is marked read-only or you opened it from a read-only location, encryption settings may be disabled.
- File is in a trusted location – Files in trusted folders bypass some security prompts, but this rarely greys out the option; still, moving the file out can help.
How to Fix the Greyed-Out Option
Follow these steps in order until the option becomes active:
- Check for Shared Workbook – Go to Review tab > Share Workbook. If the checkbox “Use the old shared workbooks feature” is ticked, uncheck it and click OK. You may need to copy the file first if you want to keep the shared history.
- Save as .xlsx – Press F12 (or File > Save As) and choose “Excel Workbook (*.xlsx)” from the “Save as type” dropdown. If the file is currently .xls, this will enable modern encryption.
- Remove read-only attribute – Right-click the file in File Explorer, select Properties, and uncheck “Read-only” if it is checked.
- Close and reopen – Sometimes Excel needs a fresh session to re-evaluate the file state.
After these steps, File > Info > Protect Workbook > Encrypt with Password should be clickable. If it is still greyed out, the file may be corrupted or protected by Information Rights Management (IRM); try copying the content to a new workbook.
What Does Encrypt with Password Actually Do?
Encrypt with Password uses AES-256 encryption (in modern Excel) to scramble the entire file. Without the password, the file cannot be opened at all – even with a hex editor. This is different from Protect Sheet or Protect Workbook, which only restrict editing and can be removed without a password by knowledgeable users. File encryption is the strongest built-in protection Excel offers.
When you set a password, Excel prompts you to enter it twice. The password is case-sensitive and cannot be recovered if lost – Microsoft has no backdoor. So, store it in a password manager.
How to Choose a Strong Password
Excel does not enforce password complexity, but a weak password defeats the purpose. Use a passphrase of at least 12 characters, mixing upper and lower case, numbers, and symbols. For example: Blue!Elephant#42&Run. Avoid dictionary words, birthdays, or anything guessable. Since Excel’s encryption is only as strong as the password, a short password can be brute-forced in minutes.
Common Problems and Misconceptions
Misconception: “Encrypt with Password is the same as Protect Sheet.” No – protecting a sheet only prevents editing; anyone can still read the data. Encrypting with a password prevents opening the file at all.
Problem: “I forgot the password.” There is no built-in recovery. Third-party tools exist but are not guaranteed and may be illegal in some jurisdictions. Always keep a backup copy without encryption.
Problem: “The option is greyed out on a file I just created.” If you created a new workbook and immediately see it greyed out, check if you are in Page Layout view or if the workbook is in “Protected View” (opened from the internet). Save it locally first.
Alternatives to Encrypt with Password
If encryption is not available, or you need different levels of protection, consider these built-in options:
- Protect Current Sheet (Review > Protect Sheet) – Locks cells and hides formulas, but data remains visible.
- Protect Workbook Structure (Review > Protect Workbook) – Prevents adding, deleting, or renaming sheets.
- Mark as Final (File > Info > Protect Workbook) – Discourages editing but is not secure.
- Digital Signature – Adds authenticity but does not encrypt.
- Save as PDF with password – Export to PDF and use a PDF tool to add a password; this is separate from Excel.
For true security, also consider encrypting the entire folder with BitLocker (Windows) or FileVault (Mac) before sharing.
Costs and Safety Considerations
Encrypt with Password is free and built into Excel. There are no extra costs. However, the safety depends on your password management. If you lose the password, the data is effectively lost. Also, encryption does not protect against malware that runs while the file is open. Always keep antivirus software active and avoid sending passwords in the same email as the file.
Frequently Asked Questions
Why is Encrypt with Password greyed out in Excel 365? The most common reason is that the workbook is in Shared mode. Go to Review > Share Workbook and uncheck the box. If that doesn’t work, save the file as .xlsx.
Can I encrypt a .xls file? Yes, but the option may be greyed out because Excel wants you to upgrade to .xlsx. Save as .xlsx first, then encrypt.
Does Encrypt with Password work on Mac? Yes, but the steps are slightly different. On Mac, go to File > Passwords > Set Password. The greyed-out issue is rare on Mac because Shared Workbook is not available in the same way.
What if I only want to prevent editing, not viewing? Use Protect Sheet or Protect Workbook instead of Encrypt with Password. Those allow anyone to open the file but restrict changes.
Is there a way to recover a lost Excel password? No official way. Some third-party tools claim to recover, but they are not reliable and may be harmful. Always keep a backup.
Related
- Excel Center Louisville KY: What It Is & How It Works
- Excel Choose Date from Calendar Cell: How to Add a Date Picker
- Excel Center Jobs: What They Are & How to Get One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- VALUE Formula Not Working in Excel? Causes and FixesIf Excel’s VALUE formula is returning an error or leaving text unchanged, check whether the cell contains a…
- Excel Dollar Sign Shortcut: Fix Cell References in FormulasIn Excel for Microsoft 365 on Windows, press F4 while editing a formula and a cell reference is…
- Excel Flash Fill Down: How to Use It and Fix IssuesYes. In Excel for Microsoft 365 on Windows, enter one or two examples in an empty adjacent column,…
- Excel Dates Sorting A-Z: Why It Happens and How to FixExcel sorts real dates A to Z in chronological order, from oldest to newest. If the dates look…
- Excel Data Validation List Not Working? Fixes That HelpIf an Excel data validation list is not working, first select the affected cell and go to Data…
- Microsoft Excel Repair Tool: Fix Damaged WorkbooksMicrosoft Excel’s built-in repair tool is called Open and Repair. In Excel for Microsoft 365 on Windows, go…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.