“The cell you’re trying to change is on a protected sheet”

The exact message — and its two versions

You clicked a cell, started typing, and Excel put up a small dialog with an information icon and a single OK button. There is no Cancel, no “try anyway”. Depending on your Excel version the wording is one of these:

• Microsoft 365 / Excel 2016 and later: “The cell or chart that you are trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password.”
• Excel 2010 / 2013: “The cell or chart you’re trying to change is protected and therefore read‑only. To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password.”

They describe the same thing. The second one names the old ribbon layout — in current Excel the button sits in the Protect group, not Changes.

What Excel is actually telling you

Someone ran Review → Protect Sheet on this worksheet. That sets a flag Excel checks before it accepts any edit, and if a password was supplied, Excel stores a hash of it alongside the flag. In the file itself this is one element — <sheetProtection> — inside that worksheet’s XML.

Two things follow from that, and both are good news:

• Your data is not encrypted. The file opened, the numbers are on screen, the formulas are intact. Protection is an edit lock layered on top of readable data, not a cipher applied to it.
• The message is not about your cell in particular. It fires on the first edit attempt anywhere the lock applies. Hunting for a “locked” property on that one cell will not get you anywhere.

Make sure it is protection and not something else

Several unrelated Excel states also refuse your keystrokes, and each has its own wording. If the dialog you got does not match the text above, check these before going further:

• “The value you entered is not valid…” — that is data validation on the cell, not sheet protection. Fix it under Data → Data Validation.
• A yellow bar reading “Protected View” or “Read‑Only” — the file came from email or the internet, or was opened read‑only. Click Enable Editing; no password is involved.
• Right‑click on a tab and Insert / Delete / Rename are greyed out — that is workbook‑structure protection, a separate lock with a separate flag.
• The Review tab shows “Unprotect Sheet” but it is greyed out — you are almost certainly in Excel for the web, which cannot change protection at all.

If the ribbon says Unprotect Sheet (rather than Protect Sheet), you have confirmed it: the sheet is protected right now.

If the password is known

The straightforward path, when you or a colleague still has it:

1. Select the tab that showed the message — protection is per worksheet, so a workbook can have some sheets locked and others free.
2. Go to Review → Unprotect Sheet.
3. Type the password if prompted. If the sheet was protected without one, the lock simply lifts with no prompt at all — worth trying first, because plenty of sheets are protected with a blank password.

If nobody has the password

This is where most people arrive, usually with a workbook inherited from someone who left, or one they protected themselves years ago. Because the protection is a flag rather than encryption, the fix is to remove the flag — the original password never has to be recovered or guessed.

1. Keep the original file untouched and work on a copy.
2. Drop the copy onto the unlock tool. It opens the workbook package in your browser, deletes the <sheetProtection> element from every worksheet that has one, and rebuilds the file. Nothing is uploaded.
3. Open the downloaded copy. The dialog is gone and every cell accepts input again.

One boundary is worth stating plainly: if Excel had demanded a password before showing you the workbook, none of this would apply. That is AES encryption of the whole file, a genuinely different mechanism, and it cannot be removed without the correct password. The fact that you saw your data and then got this dialog is what tells you that you are on the removable side of the line — see the difference between the two password types if you want to be certain.

Unlock it in seconds instead

The manual route works, but our free in‑browser tool does the same thing in one drop — nothing is uploaded, everything runs on your device.

Frequently asked

Related guides

Unlock a protected .xls file (old Excel format) · Unprotect Sheet greyed out in Excel for the web · Unprotect an Excel sheet on a Mac