Fix the "Cell or Chart Is on a Protected Sheet" Error

Updated · about 3 min read

You click a cell, start typing, and Excel stops you with: "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet." Here's exactly what that means and how to get editing again.

What the error means

This message is purely about sheet protection. Someone — possibly you, possibly whoever sent the file — turned on Review → Protect Sheet. That setting locks cells against editing while leaving the data fully visible.

Nothing is wrong with your file or your copy of Excel. The protection is just a flag telling Excel to refuse edits. Remove the flag and the error disappears for good. To understand how this differs from a file that won't even open, see protection vs encryption.

If you know the password

1. Go to the Review tab.
2. Click Unprotect Sheet.
3. Enter the password if prompted. The sheet is now editable.

If protection was set without a password, Unprotect Sheet removes it immediately with no prompt.

If you don't know the password

Because sheet protection isn't encryption, a forgotten password is not a dead end — the lock can be removed without it.

Drop the file into the unlocker and it strips the protection marker from every sheet, then hands back an editable copy. Prefer to do it by hand? The manual ZIP method achieves the same thing by editing the file's XML directly.

If unprotecting doesn't fix it

If you've removed sheet protection and a cell still won't change, check these:

• Shared/co-authored workbook: edits may be restricted by sharing settings rather than sheet protection. Turn off sharing under Review.
• Data validation: the cell may reject certain values (it shows a different error mentioning "value" or a custom message, not "protected sheet").
• The file is read-only: if the title bar says "Read-Only," save a fresh copy with File → Save As first.