Excel file locked for editing? Here’s how to unlock it.

An Excel file locked for editing means someone — or something — is holding the only pen: another person mid-edit, or a ghost copy that never closed. Sometimes that “another user” is you. Work through these in order.

01 · Quick checks first.

  1. Read the name in the message. Excel usually tells you who has the file: “locked for editing by [name]”. If it’s a colleague, the honest options are to ask them to close it, wait, or open read-only — there’s no button that kicks them out.
  2. Don’t need to edit right now? Open it read-only and get on with reading. In the browser you can also select Viewing in the top-right and choose Request more access.
  3. Need to edit right now? Save a copy, make your changes there, and merge them once the original frees up.
  4. Says it’s locked by you? A common cause — and the quickest to clear, usually in a couple of minutes. Step 02.

02 · When “another user” is you.

If the lock is under your own name, a copy of the file is still open somewhere under your account:

  1. Close the file everywhere. Check your other computer, your laptop at home, and any browser tab with Excel for the web — the browser counts as a device.
  2. Check for a ghost Excel. An Excel that crashed or didn’t close cleanly can hold the file open with no window to see. Open Task Manager (Ctrl + Shift + Esc), find Excel in the list, and choose End task.
  3. Then wait a few minutes. Even once the file is closed everywhere, the server can hold the lock briefly before releasing it. Give it five minutes — it often clears on its own.

03 · Stop it happening: co-author instead.

Shared workbooks don’t have to take turns. Set them up to co-author and everyone edits at once, with no locks:

  • Keep the file on OneDrive or SharePoint — not a local folder, a mapped server drive, or Dropbox/Google Drive. Those can’t co-author.
  • Everyone opens it in Excel for Microsoft 365 or Excel for the web. Older one-off versions — Excel 2016, 2019, and 2021 LTSC — can’t co-author, and one person on an old version locks the file for the whole office.
  • Use a modern format: .xlsx, .xlsm, or .xlsb. Ancient .xls workbooks lock.
  • Skip file encryption. A password-protected workbook can’t co-author — if the file doesn’t need it, remove it under File → Info → Protect Workbook.
  • Keep OneDrive syncing. A paused or out-of-date OneDrive on one machine can cause stale locks for everyone. The OneDrive not syncing guide covers that fix.

04 · Or let KoalaFix do it.

That’s a fair bit of detective work for one locked spreadsheet — and it’s exactly what KoalaFix handles for you. Your team member just says “the budget file is locked,” and KoalaFix sorts it out on the spot — no ticket, no chasing whoever set up the shared drive.

Try KoalaFix free → See how it works

05 · FAQ.

Why does Excel say the file is locked for editing by me?

A copy is open somewhere else under your name — another device, a browser tab, or an Excel instance that didn’t close properly. Close it everywhere, then give the server a few minutes to release the lock. It clears on its own.

How do two people edit the same Excel file at the same time?

Put the file on OneDrive or SharePoint and open it in Excel for Microsoft 365 or Excel for the web, saved as .xlsx, .xlsm, or .xlsb. That’s co-authoring — simultaneous editing, no locks. One person on Excel 2016, 2019, or 2021 LTSC breaks it for everyone.

Can I kick the other person out of the file?

No — there’s no force-unlock button. Ask them to close it, wait it out, open read-only, or work in a copy and merge later. If it happens weekly, set up co-authoring and the problem disappears.