How To Fix Excel File Locked For Editing (2026)
Excel says a file is locked for editing when it thinks someone, or something, already has the workbook open.
That someone is often you, on another device or in a session that never closed properly.
These steps come from Microsoft’s support pages and are ordered from the quickest fix to the more involved ones.
Quick answer: who has the file open
| Likely cause | What to do |
|---|---|
| You have it open on another device, or a past session did not close | Close it everywhere, then wait a few minutes |
| Another person has it open | Wait, open it read-only, or ask them to close it |
| Excel 2016, 2019 or 2021 LTSC is in use | Switch to a version that supports co-authoring |
| File is in the wrong location or format | Move it to OneDrive or SharePoint and save as .xlsx |
| OneDrive sync is outdated or paused | Update the sync app and resume syncing |
Release a lock you created yourself
- Close the workbook on every device where you may have opened it.
- Close Excel completely, then reopen the file.
- If the message returns, wait a few minutes for the server to release the lock.
Microsoft also lists a restart as the fix when a crash left the app believing the file was still open.
A background Office process can hold the file too, so closing the app fully matters more than closing the window.
When another person has the file open
You can wait until they close it, or open the file as read-only.
You can also ask them to close the file, check it in, or give you edit permission.
To request access, select Viewing in the upper-right corner, then Request more access.
Choose Ask to edit or Ask to review, add a note if you like, and send the request.
The owner gets an email and can grant or decline it.
If you only need to add changes, Microsoft suggests making a copy and turning on tracked changes on the Review tab so you can merge them later.
Use a version of Excel that supports co-authoring
Everyone editing the same workbook at once needs a version that supports it.
| Supported | Not supported |
|---|---|
| Excel for Microsoft 365 (Windows and Mac), Excel for the web, Excel for Android, Excel for iOS, Excel Mobile | Excel 2016, Excel 2019, Excel 2021 LTSC |
Excel for Microsoft 365 requires you to sign in with a Microsoft 365 subscription.
If you are unsure which version others use, opening the file in Excel for the web in your browser is the simplest workaround.
Store the file where co-authoring works
Co-authoring works for files in OneDrive, OneDrive for Business and SharePoint in Microsoft 365.
It does not work for server paths such as \\server\folder, Dropbox, Box, Google Drive, local folders or SharePoint On-Premises libraries.
Move the workbook to a supported location and have everyone open it from there.
If you keep hitting OneDrive problems, see how to fix OneDrive stuck on processing changes.
Save the workbook in a supported format
Excel co-authoring works with .xlsx, .xlsm and .xlsb files.
The Strict Open XML Spreadsheet format does not support it.
- On Windows, select File > Save As > Browse.
- Open the Save as type list and choose a supported format.
- On Mac, select File > Save As and choose the format.
If you cannot see the extension on your file, follow how to show file extensions in Windows 11.
Check the OneDrive sync app on Windows
Microsoft says an outdated or paused OneDrive sync app can cause the lock.
Install the latest version of the OneDrive sync app and make sure syncing is not paused.
Remove features that block co-authoring
Some workbook features stop others from editing at the same time.
| Feature | Windows fix | Mac fix |
|---|---|---|
| Shared Workbook | Turn it off first | Turn it off first |
| Password or restricted access | File > Info > Protect Workbook | Review tab > Protect Workbook; or File > Restrict Permissions > No Restrictions |
| Refresh data when opening file | Table Tools Design > Refresh > Connection Properties, uncheck it | Table tab > Refresh > Connection Properties, uncheck it |
| Problem add-in | File > Options > Add-Ins > Excel Add-ins > Go, clear the box | Tools > Excel Add-ins, clear the box |
If you opened a SharePoint snapshot, open the workbook itself instead.
Marked as Final, checked out or no permission
A file marked as Final is locked against edits, and Microsoft says this can be turned off in the desktop Microsoft 365 apps.
On SharePoint, a checked-out file blocks other authors until it is checked in, so contact the person who has it.
If you simply lack edit permission, ask the file owner to grant it.
A password-protected file cannot be opened without the password, and Microsoft states there is no way around it.
Other causes Microsoft lists for a file you cannot edit
Microsoft’s general “Why can’t I edit this file” page adds a few causes that apply to Excel workbooks too.
| Cause | Fix |
|---|---|
| The app still thinks the file is open after a crash | Close the app, then restart the computer |
| Another author uses an earlier version such as Excel 2010 | Ask them to save and close, and use the current version yourself |
| The server does not support co-authoring, or it was disabled | Move the file to OneDrive or SharePoint in Microsoft 365, or ask your administrator |
| The file is in an older or incompatible format | Save a new copy in a modern format such as .xlsx and work from it |
| You do not have edit permission | Ask the file owner to grant it |
Co-authoring also does not work when a file is encrypted, uses Information Rights Management or contains ActiveX controls.
Microsoft does not describe a menu for removing those, so ask the file owner for an unprotected copy.
If Excel still says the file is locked
Restart your computer, because Microsoft lists a restart for locks left behind by a crash.
If Excel itself is crashing or will not open properly, try repairing Microsoft 365 apps on Windows 11.