Home / Error Lookup / EXCEL-LOCKED-FOR-EDITING

EXCEL-LOCKED-FOR-EDITING

Excel File Is Locked for Editing by Another User Applies to: Windows 7, Windows 10, Windows 11

What it means

Excel believes someone else already has the file open, so it opened your copy as read-only.

Quick fix steps

  1. Confirm with the named person whether they genuinely have it open.
  2. On OneDrive/SharePoint, wait a few minutes — the lock can persist briefly after the other session closes.
  3. For local/network files, look for a hidden "~$filename" lock file in the same folder and delete it if no one is actually editing.
For the full step-by-step walkthrough, see "File Is Locked for Editing by Another User".

Frequently Asked Questions

Can I still see the content while it's locked?
Yes — opening it as read-only lets you view and copy the content immediately, even while someone else (or a stale lock) prevents full editing access.
Why would it show as locked when I'm the only one who opened it?
A previous session of Excel may not have closed properly, leaving a stale lock file behind even though no one is actively editing — this is common after a crash or forced shutdown.

Other error codes

#REF! — #REF! Error

A formula is pointing to a cell that no longer exists — usually because a row, column, or sheet it referenced was deleted.

#VALUE! — #VALUE! Error

The formula received the wrong type of data — commonly text where it expected a number.

#DIV/0! — #DIV/0! Error

The formula is dividing by zero or by an empty cell.

#N/A — #N/A Error

A lookup formula (VLOOKUP, MATCH, XLOOKUP, INDEX/MATCH) couldn't find a matching value.