Excel Workbook Protection: What Is Locked and How to Fix It

Errors & fixes · Updated November 18, 2026

If an Excel workbook is protected, Excel is restricting an action because a worksheet, the workbook structure, or the file itself has a protection setting. To identify which one, check the message you see and open the Review tab: sheet protection and workbook-structure protection are different from a password required to open an encrypted file.

What “workbook protected” can mean

People often use “protected workbook” to describe several Excel features, but they do not all lock the same things. A workbook is the Excel file; it can contain multiple worksheets. Protection may apply to the contents of one sheet, the arrangement of sheets, or access to the file as a whole.

  • Worksheet protection limits actions on a particular sheet, such as changing locked cells, inserting rows, or editing objects. It can also allow selected actions, depending on the protection settings.
  • Workbook-structure protection restricts changes to the workbook’s sheet structure, such as adding, deleting, moving, hiding, unhiding, or renaming worksheets.
  • Password-to-open encryption requires a password before Excel can open and display the workbook’s contents.

These settings can be used separately or together. For example, a workbook might open normally, let you select cells, but prevent you from renaming a worksheet. That points to structure protection, not file encryption. A message that a cell is on a protected sheet points instead to worksheet protection.

How to identify what is protected

Start with the action Excel will not let you perform. If you can open the file but cannot edit certain cells, try another cell or worksheet. A restriction affecting just one sheet is a strong clue that sheet protection is involved. If you can edit cells but cannot add or rename a tab, check for workbook-structure protection.

In Excel for Microsoft 365 on Windows, select the Review tab and look for the protection commands, such as Protect Sheet or Protect Workbook. Depending on the current state and Excel’s layout, a command may offer to protect an unprotected item or to unprotect an item that is already protected. The command names and available options can vary somewhat across versions and ribbon layouts.

If Excel asks for a password before showing the workbook, the file is password-encrypted. If it opens in Protected View with a warning, that is a separate safety feature: Excel has opened the file in a restricted mode because of its source or security assessment. Protected View is not the same as a worksheet password. Only enable editing when you trust the file and its source.

What worksheet protection does

Worksheet protection is designed to prevent accidental or unauthorized changes to parts of a sheet. It is commonly used for forms, templates, and reports where people should enter information in designated cells without altering labels, formulas, or layout. The person protecting the sheet can choose which actions remain available, so two protected sheets may behave differently.

Cells have a Locked setting, but that setting normally has no effect until sheet protection is turned on. A common setup is to leave formula cells locked, unlock the cells intended for user input, and then protect the sheet. Users can then fill in the unlocked fields while the formulas remain protected from ordinary editing. Protection does not automatically make a sheet read-only in every respect: options may still permit selecting cells, sorting, filtering, or formatting.

To inspect the cell setting in Excel for Microsoft 365 on Windows, select a cell and open Format Cells (Ctrl+1), then check the Protection tab. On Mac, Command+1 opens Format Cells. The Locked checkbox is a cell-format property; changing it alone does not turn sheet protection on or off. In a protected sheet, changing locked cells is restricted, while unlocked cells are intended to remain editable.

What workbook-structure protection does

Workbook-structure protection controls changes to the collection and arrangement of worksheets, rather than locking the cell contents across the workbook. When it is enabled, commands such as inserting, deleting, moving, copying, hiding, unhiding, or renaming sheets can be unavailable or prompt for a password. This is useful when a workbook’s tabs are part of a carefully maintained template or reporting process.

Structure protection does not necessarily stop someone from editing cells on an unprotected sheet. Conversely, protecting a sheet does not necessarily stop someone from adding another worksheet or changing the tab order. If the problem is a disabled sheet-tab command, check the workbook protection control on the Review tab rather than repeatedly trying to unprotect individual cells.

How to remove protection when you have authorization

If you know the password and have permission to make the change, use the command matching the restriction. Save a working copy first if the workbook is important, especially before changing a shared template or a file used by others.

  1. For a protected worksheet: select the affected sheet, open Review, and choose Unprotect Sheet. Enter the password if Excel asks for it. Repeat for other protected sheets as needed.
  2. For workbook structure: open Review and choose the workbook-protection command to turn off structure protection. Enter the password if requested.
  3. For a password required to open the file: open the workbook with the password, then go to File > Info > Protect Workbook > Encrypt with Password. Clear the password field, confirm the change, and save the file. Menu wording can differ by Excel version.

On Mac, the Review tab also provides sheet and workbook protection controls, though their placement and labels can differ by release. The Windows File > Info route is not presented identically in every Mac version; look for the password or protection settings in Excel’s workbook-protection menus. Excel for the web may not expose every desktop protection or password-management option, so use the desktop app when a command is unavailable.

Removing protection can expose formulas or make it possible to alter a carefully designed template. If you are changing a shared workbook, confirm that the owner expects the protection to be removed, and save under a new name if you need to preserve the original setup.

Passwords, recovery, and safety

Excel does not provide a general way to reveal a forgotten worksheet or workbook-structure password. If you do not know it, ask the workbook’s creator or administrator, check an approved password manager or internal documentation, or restore an authorized earlier copy. For a file that requires a password to open, losing the password can mean losing access to its contents; Microsoft cannot simply supply the missing password.

Be cautious with websites or utilities that promise to “crack” a workbook. Uploading a confidential spreadsheet to an unknown service can expose its data, and tools that claim to remove protection may be unsafe or inappropriate. If the workbook belongs to an organization, contact its IT team or file owner and follow its recovery process. Do not try to defeat protection on a file you are not authorized to change.

It is also important to understand the limits of sheet and structure protection. Microsoft describes these features as protection against changes, not as a substitute for securing sensitive information. They are useful for preventing accidental edits, but they should not be treated as strong confidentiality controls. Use file encryption and appropriate access permissions when the goal is to restrict who can read the data.

Common problems and misconceptions

  • “I can select a cell, so the sheet cannot be protected.” Selection may still be allowed on a protected sheet. The restriction may apply only when you try to edit a locked cell or perform a blocked action.
  • “The Locked checkbox is checked, so the cell must be locked now.” The Locked property takes effect when worksheet protection is enabled. By itself, it does not prevent editing.
  • “Unprotect Sheet should let me rename the tab.” Renaming a sheet is governed by workbook-structure protection. Check that setting if the tab operation remains unavailable.
  • “Protected View is asking for the sheet password.” Protected View is a separate restricted mode related to file safety. It is not the same as worksheet protection or a password-to-open prompt.
  • “The workbook opens, so it has no password protection.” It may still have a password-protected structure or protected sheets. A password-to-open setting is only one kind of protection.

Another possible source of limited editing is access control outside Excel, such as a file saved in a shared location with read-only permissions. If the Review-tab protection commands do not explain the issue, check whether the file is marked read-only, whether you have edit access to its storage location, and whether another user or organizational policy controls the file. Those restrictions may require help from the file owner or administrator rather than an Excel protection command.

Choosing the right protection for a workbook

For a reusable form, unlock only the intended input cells and protect the sheet so that users are less likely to overwrite formulas or headings. For a workbook whose tab names and order must remain stable, structure protection may be appropriate. For information that must not be readable by someone without permission, use password-to-open encryption and control access to the file’s storage location.

These measures solve different problems, and combining them may be sensible. For instance, a budget template could use unlocked cells for entries, sheet protection to guard formulas, and structure protection to keep its tabs in place. If the file contains confidential data, those editing restrictions do not replace encryption or suitable sharing permissions. Choose the narrowest control that meets the real need, and document passwords securely for authorized users.

Frequently Asked Questions

How do I know if an Excel workbook is protected?
Check what Excel blocks. A warning about editing a protected cell suggests sheet protection; disabled sheet-tab changes suggest workbook-structure protection; a password prompt before opening indicates file encryption. Review-tab protection commands can help confirm the first two.

Can I edit a protected Excel sheet?
You can edit cells the sheet owner left unlocked, and some other actions may be permitted. To edit locked cells, you generally need authorization and the password to unprotect the sheet or change its settings.

Can I remove Excel protection without the password?
Excel does not offer a general password-recovery feature for protected sheets, workbook structure, or encrypted files. Ask the owner or administrator, locate an authorized copy, or use your organization’s recovery process rather than relying on untrusted unlocking services.

Does Protect Sheet encrypt my Excel file?
No. Worksheet protection limits editing actions; it does not encrypt the workbook’s contents. Password-to-open encryption is a separate feature intended to restrict access to the file itself.

Why can’t I rename or move an Excel worksheet?
Workbook-structure protection may be enabled, which restricts tab operations. If you have permission and the password, use the workbook protection control on the Review tab to turn it off before changing the sheet arrangement.

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.