Home / Guides / Excel Errors & Fixes

"File Is Locked for Editing by Another User"

Beginner Excel Errors & Fixes Applies to: Windows 7, Windows 10, Windows 11

Excel opens the file as read-only because it thinks someone else already has it open.

Before you start: save any open work and note down what you were doing when the problem started — that context helps if you need to search further or ask for help.
  1. Check with the person named in the message — if they genuinely have it open, wait or ask them to close it.
  2. If no one actually has it open, this is usually a leftover lock file. On OneDrive/SharePoint, this can take a few minutes to clear itself after a previous session ends.
  3. For a file on a shared network drive, look for a hidden lock file starting with "~$" in the same folder and delete it if no one is actually editing.
  4. If it's a local file falsely showing as locked, restart the PC — a crashed previous Excel session can leave a phantom lock until reboot.
  5. Use File > Info > "Always open read-only" only as a workaround if you just need to view it; for genuine editing, the lock needs to be cleared first.
Still not fixed? Send us the details and we'll help you dig further, or browse related guides in Excel Errors & Fixes.

Frequently Asked Questions

Does "locked for editing" mean someone else has it open right now?
Usually yes, if you're on a shared drive or OneDrive with others — but it can also mean a previous session of Excel didn't close properly and left a stale lock file behind, even if no one is actually editing it.
Is it safe to open it as read-only and make my own copy?
Yes — this lets you view and copy the content without waiting, though you'll need to merge your changes back in later once the original is available for editing again.

Related guides

Excel Won't Open At All

Double-clicking a spreadsheet or the Excel icon does nothing, or Excel opens then immediately closes.

Beginner

Excel File Is Corrupted or Unreadable

"Excel found unreadable content" or the file simply won't open and shows a corruption warning.

Intermediate

Formulas Not Recalculating Automatically

You change a cell but the formulas depending on it don't update until you do something else.

Beginner