If Excel password protection is not working, first identify what you protected: encrypt the workbook to require a password to open it, use Protect Sheet to limit edits, or protect workbook structure to restrict sheet changes. These are separate features, and applying one does not automatically do the job of the others. In Microsoft 365 for Windows, file encryption is under File > Info > Protect Workbook > Encrypt with Password.
Identify What the Password Is Supposed to Protect
A password prompt when opening a file is different from a password prompt when changing a worksheet. Excel uses the word protection for several controls, so the first useful troubleshooting step is to test the exact behavior you expect.
- Require a password to open the file: Encrypt the workbook. Someone without the password should not be able to open the encrypted file in a compatible desktop version of Excel.
- Stop edits to cells or objects on a sheet: Protect that worksheet. This is mainly an editing control, not strong file encryption.
- Prevent adding, deleting, renaming, moving, hiding, or unhiding sheets: Protect the workbook structure. This does not lock the contents of each sheet.
For example, if you chose Review > Protect Sheet but can still open the workbook without a prompt, that is expected: sheet protection does not require a password to open the file. If you can open the file and edit cells that you expected to be locked, check whether sheet protection is on and whether those cells were left unlocked.
Encrypt the Workbook to Require a Password at Opening
In Excel for Microsoft 365 on Windows, open the workbook and choose File > Info > Protect Workbook > Encrypt with Password. Enter the password, confirm it when prompted, and save the workbook. Close it, then reopen the saved file to verify that Excel asks for the password. Testing a reopened copy matters: setting the password and leaving the file open does not test the opening requirement.
Passwords are case-sensitive. Check Caps Lock, the keyboard layout, and whether the password contains characters that may be typed differently on another keyboard. If you paste the password, make sure you have not included a leading or trailing space. Do not confuse a password required to open a file with a password used only to modify it; older or alternate save workflows can offer different password options.
On Excel for Mac, file password options are generally available from File > Passwords, though labels and layout can differ by release. Excel for the web does not provide the same full desktop controls for workbook encryption; use the desktop app when you need to set or remove file-open encryption. An encrypted workbook may not be usable in the web app, so check the current Excel support information before choosing a web-based workflow.
Check Worksheet Protection and Locked Cells
To prevent edits on a sheet in Windows, select Review > Protect Sheet, choose the actions users may still perform, optionally enter a password, and confirm it. The password is applied when protection is enabled. If the command instead offers Unprotect Sheet, protection is currently on; try editing a cell that should be restricted and note whether Excel displays a prompt.
Protection does not mean every cell is automatically inaccessible in every situation. Cells have a Locked setting, and that setting takes effect when the worksheet is protected. By default, cells are usually marked locked, but a workbook author may have unlocked input cells so users can fill in a form. To inspect a cell, select it, press Ctrl+1 on Windows, open the Protection tab, and check Locked. On Mac, use Command+1 to open Format Cells. If users should enter data in designated cells but not overwrite formulas, the intended setup is commonly to unlock only the input cells and then protect the sheet.
Also review the permissions selected in the Protect Sheet dialog. If you allow users to format cells, insert rows, sort, or use other actions, those actions may remain possible while the sheet is protected. Protection is selective: it is not necessarily a command to make every part of the sheet read-only. If an object such as a chart or shape can still be changed, inspect its protection properties and the allowed actions, rather than assuming cell locking covers every object.
Protect Workbook Structure Separately
Workbook structure protection controls changes to the sheet tabs, not changes inside the sheets. In Windows, choose Review > Protect Workbook, select the structure option if shown, enter and confirm a password, then save. Depending on the Excel build and ribbon layout, the command may present the structure control directly. A protected structure can stop users from renaming, deleting, moving, hiding, unhiding, or adding worksheets.
This feature is often mistaken for file encryption because both can use passwords. A colleague may be able to open a workbook and read its data while being unable to alter the sheet layout. Conversely, encrypting a workbook does not by itself prevent an authorized person who knows the opening password from editing sheets. For a workbook that needs both controls, set file encryption and apply the relevant worksheet or structure protections separately.
Common Reasons Protection Appears Not to Work
Before changing passwords, match the symptom to the feature. These checks resolve many cases without rebuilding the workbook:
- No password prompt when opening: You may have protected a sheet or structure instead of encrypting the file. Use File > Info and check the workbook encryption setting.
- Some cells remain editable: The sheet may not be protected, or those cells may be unlocked. Check Review and inspect the Locked setting in Format Cells.
- Users can still perform certain actions: Those actions may have been allowed in the Protect Sheet options. Unprotect and reapply protection with the intended permissions.
- The password seems rejected: Check capitalization, spaces, keyboard layout, and whether you are entering the password for the correct protection layer. A sheet password is not necessarily the file-opening password.
- The change disappears after saving: Confirm that you saved the same file you later reopened. Copies in different folders, email attachments, and cloud-synced versions can have similar names.
- The file opens without asking on another computer: Verify that you are opening the encrypted file itself, not a previously opened workbook, an unencrypted copy, or a version restored from a different location.
For cloud files, check the file name and location in the title bar and verify sync has finished before testing another device. If you use SharePoint or OneDrive version history, an earlier version may not contain the latest protection settings. Keep an unprotected backup in a controlled location while diagnosing the issue, but do not distribute it as though it were protected.
Understand Excel for the Web and Mac Differences
Excel for the web has a different feature set from the Windows desktop application, and menu availability can change as Microsoft updates the service. If a protection command or option is missing, open the workbook in the desktop app and configure it there. In particular, use desktop Excel for dependable management of password-to-open encryption and workbook structure protection. A password-encrypted file is not the same as an ordinary workbook that happens to be shared through a browser.
Excel for Mac also separates file passwords from sheet protection, even though the menu location for file passwords differs from Windows. Review is the relevant ribbon tab for worksheet controls on both platforms, but dialog details can vary. When troubleshooting across Windows and Mac, test the saved file in the version and location where recipients will actually use it; do not assume that a setting visible in one interface appears identically in another.
Security Limits, Password Loss, and Safer Sharing
Workbook encryption is the appropriate Excel feature when the goal is to prevent someone without a password from opening the file. Worksheet and structure protection are useful for preventing accidental changes or guiding ordinary collaboration, but Microsoft does not present sheet protection as a substitute for encrypting sensitive data. Do not rely on a protected worksheet to conceal confidential information from a determined recipient who can access the workbook.
Choose a unique, hard-to-guess password and store it in an approved password manager or another secure record. Send the password through a separate channel from the file when practical. If you forget a password, Microsoft cannot retrieve it for you, and there is no supported universal recovery command. Check your own password records, ask the workbook owner, or restore an authorized copy from backup or version history. Be cautious with third-party recovery tools, especially when a workbook contains sensitive information; granting an unknown tool access to the file may create a separate privacy risk.
For shared business files, consider whether access controls on OneDrive, SharePoint, or another managed storage service are a better fit for controlling who can view or edit a document. Those permissions are separate from Excel passwords and may be easier to revoke. For highly sensitive material, store only the information people need in the workbook and follow your organization’s approved data-handling rules.
Frequently Asked Questions
Why can I edit an Excel sheet even though it is password protected? The sheet may not currently be protected, or the cells you are editing may have been unlocked before protection was applied. Check Review for the sheet’s protection state and inspect Locked in Format Cells. Also review which actions were allowed in the protection settings.
Does Protect Sheet require a password to open the workbook? No. Protect Sheet controls selected edits after the workbook is open. To require a password before someone can open the file, use Encrypt with Password under File > Info > Protect Workbook in Excel for Windows.
How do I remove an Excel password? For file-opening encryption in Windows, open the file with its password, go to File > Info > Protect Workbook > Encrypt with Password, clear the password field, confirm, and save. To remove sheet or structure protection, use the relevant Unprotect command and supply its password if requested. Only remove protection if you are authorized to do so.
Can Microsoft recover a forgotten Excel password? Microsoft cannot look up or restore a forgotten workbook password. Check a password manager, secure records, the file owner, or an authorized backup. If it is the opening password, the encrypted file may not be recoverable through ordinary Excel controls without the correct password.
Why does Excel for the web not ask for my workbook password? You may be using sheet protection rather than file encryption, or you may be working with a web-compatible copy that is not the encrypted file. Excel for the web has limitations compared with desktop Excel; verify the file’s encryption in the desktop app and test the actual saved file.
Related
- Notepad to Excel Conversion: Steps and Common Fixes
- New Employee Training Schedule Template in Excel
- New Hire Checklist Template in Excel: What to Include
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- IMAP Not Working in Outlook? Troubleshoot the CauseIf IMAP is not working in Outlook, first confirm your internet connection and your email provider’s current server…
- Why Is the Hyperlink Not Working in Microsoft Word?A hyperlink in Word usually will not open because Word requires Ctrl+click on Windows, the link is only…
- Deleting Columns in Excel Not Working? Try These FixesIf deleting columns in Excel is not working, first select the column letter, then choose Home > Cells…
- Excel Formulas Not Calculating? Fix the Common CausesIf Excel formulas are not calculating, first choose Formulas > Calculation Options > Automatic, then press F9 to…
- Excel Goal Seek Not Working? Fix These Common ProblemsIf Excel Goal Seek is not working, first confirm that the Set cell contains a formula linked to…
- XLOOKUP Name Error: Causes, Checks, and Fixes in ExcelIf XLOOKUP returns #NAME?, Excel usually does not recognize something in the formula: the function name may be…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.