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 causeWhat to do
You have it open on another device, or a past session did not closeClose it everywhere, then wait a few minutes
Another person has it openWait, open it read-only, or ask them to close it
Excel 2016, 2019 or 2021 LTSC is in useSwitch to a version that supports co-authoring
File is in the wrong location or formatMove it to OneDrive or SharePoint and save as .xlsx
OneDrive sync is outdated or pausedUpdate the sync app and resume syncing

Release a lock you created yourself

  1. Close the workbook on every device where you may have opened it.
  2. Close Excel completely, then reopen the file.
  3. 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.

SupportedNot supported
Excel for Microsoft 365 (Windows and Mac), Excel for the web, Excel for Android, Excel for iOS, Excel MobileExcel 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.

  1. On Windows, select File > Save As > Browse.
  2. Open the Save as type list and choose a supported format.
  3. 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.

FeatureWindows fixMac fix
Shared WorkbookTurn it off firstTurn it off first
Password or restricted accessFile > Info > Protect WorkbookReview tab > Protect Workbook; or File > Restrict Permissions > No Restrictions
Refresh data when opening fileTable Tools Design > Refresh > Connection Properties, uncheck itTable tab > Refresh > Connection Properties, uncheck it
Problem add-inFile > Options > Add-Ins > Excel Add-ins > Go, clear the boxTools > 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.

CauseFix
The app still thinks the file is open after a crashClose the app, then restart the computer
Another author uses an earlier version such as Excel 2010Ask them to save and close, and use the current version yourself
The server does not support co-authoring, or it was disabledMove the file to OneDrive or SharePoint in Microsoft 365, or ask your administrator
The file is in an older or incompatible formatSave a new copy in a modern format such as .xlsx and work from it
You do not have edit permissionAsk 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.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *