Excel file locked for editing by me (or someone else)? How to unlock it.

Last updated

An Excel file locked for editing means something already has the file open: a colleague part-way through an edit, or a copy of Excel that never closed properly. 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 it: “locked for editing by [name]”. If it’s a colleague, your 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? Common, and usually the quickest to clear. Step 02.

Locked by 'me' but you don't have it open: kill the ghost Excel process and the owner file

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 on screen. 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.

Save your work before ending Excel. If a local or network-folder workbook remains locked after everyone has closed it, make a backup and check for its temporary owner file (a matching filename beginning with ~$). Only remove that specific owner file once you have confirmed nobody is editing the workbook. Never delete the workbook itself. For SharePoint or OneDrive server-side locks, wait for the lock to expire or contact Microsoft support.

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. Older .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 · How KoalaFix can help.

If a stuck Excel process on your PC is holding the file open, KoalaFix can close that process to release the lock. Save any work you can before proceeding: closing Excel can lose unsaved changes in other open workbooks.

A colleague’s lock, a SharePoint or OneDrive checkout, or a temporary owner file left behind on a shared drive needs a different step. KoalaFix’s Excel restart does not clear those. Ask the person editing to close the file, have the checkout owner check it in, or ask your IT contact to investigate a remaining lock. Follow the owner-file checks above before removing any temporary file.

Download KoalaFix → 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.

07 · What KoalaFix can handle.

See the full capability map for what KoalaFix fixes automatically, what asks for approval, and what still needs a person.