Guides / Excel file locked for editing by another user

Part of: Files, sync and sharing problems

Last reviewed 6 Oct 2026 · By Harry

Excel file locked for editing by another user

Excel says the file is locked for editing by you or a colleague who closed it hours ago? Owner files, co-authoring, network shares and stale locks.

The finance team's master spreadsheet opens read-only with File in use — locked for editing by another user. Sometimes the named user went home at lunchtime. Sometimes it names the person trying to open it. This ticket arrives every month-end, and the fix depends on where the workbook is stored: a network file share, or SharePoint/OneDrive with co-authoring.

Where does the file live?

Look at the path in Excel (File → Info) or in the title bar.

• Network share or mapped drive (S:\ or \\server\share). Excel uses lock files and SMB file locks. Only one person can edit at a time. Co-authoring does not work here.
• SharePoint, Teams or OneDrive. Co-authoring should allow many editors at once, provided the file format and settings support it.
• Synced OneDrive folder opened from File Explorer. It behaves like SharePoint if AutoSave is on; if the sync client is broken, it behaves like a local file and conflicts appear.

On a network share

1. Ask the named user to close Excel completely. Not just the workbook — the whole application, including any background Excel process.
2. Owner file. When a workbook is open, Excel creates a hidden file beginning with ~$ in the same folder. If Excel crashed, that file stays behind and the lock persists. With nobody using the workbook, show hidden files in File Explorer and delete the matching ~$ file.
3. Locked by yourself. Usually another Excel instance on your own PC still holds the file, or you have it open on another computer or a remote desktop session. Check Task Manager for extra EXCEL.EXE processes and end them after saving other work.
4. Server-side open file. An admin can open Computer Management on the file server → Shared Folders → Open Files, find the workbook and close the handle. Warn the holder first — closing a handle mid-save can corrupt the file.
5. Preview pane. File Explorer's preview pane and some antivirus scans briefly hold files. Turn the preview pane off in folders full of shared workbooks.

On SharePoint or OneDrive

1. Open in Excel for the web. Click the file in the browser. If the web version opens for editing, co-authoring works and the desktop client is the problem.
2. Turn on AutoSave. The toggle in the top-left of desktop Excel must be on for co-authoring. Files opened from a local copy or email attachment are not co-authorable.
3. File format. Co-authoring needs modern formats such as .xlsx, .xlsm or .xlsb. Old .xls files and CSVs open exclusively. Save a copy as .xlsx.
4. Unsupported features. Workbooks using legacy shared workbook mode, some protection settings, or certain features block co-authoring. Excel usually says why in the yellow bar — read it.
5. Checked out. If the library requires check-out, the file may be checked out to someone. In the library, check the file's status; the owner or a site owner can check it back in or discard the checkout.
6. Update Office. Old Excel builds co-author poorly. Make sure everyone is on a supported Microsoft 365 Apps channel.
7. Clear the Office cache. Stale upload cache causes phantom locks. Close all Office apps, then clear the Office Document Cache via the OneDrive settings or Office Upload Centre where available.

Admin checks

• Library settings. Require check-out, or version settings with minor versions and content approval, change how locks behave. Turn off required check-out for libraries meant for collaborative editing.
• Sync client health. If the OneDrive client is stuck, users effectively edit local copies and generate conflict files like Budget-LAPTOP123.xlsx. See OneDrive not syncing.
• Move busy workbooks off file shares. If several people need to edit a workbook at once, a SharePoint library with co-authoring is the long-term fix.
• Service health. Only if co-authoring fails tenant-wide, check the SharePoint and OneDrive status page and Service health for an advisory.

When to escalate

Escalate to Microsoft only when co-authoring fails across many files and users in Excel for the web as well as desktop. Escalate to the file server owner when handles cannot be released. A leftover owner file is a two-minute fix — document where it lives so the next person does not wait an hour.

Related status pages

• SharePoint and OneDrive
• Microsoft 365

Related guides

• OneDrive files missing, cloud-only, or won’t open offline
• OneDrive not syncing or 'sync paused': how to fix it
• Mapped network drive disconnected or red X in File Explorer

FAQ

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

Someone has it open, Excel crashed and left a hidden owner file, or the file is on a network share where only one person can edit. On SharePoint, co-authoring needs AutoSave and a modern file format.

Why is Excel locked by me?

Another Excel process on your PC, or another device or remote session you use, still has the workbook open. Close all Excel windows and check Task Manager for leftover Excel processes.

How do I remove a stale Excel lock?

With nobody using the workbook, delete the hidden file starting with ~$ in the same folder, or ask an admin to close the open file handle on the server.

Can several people edit the same Excel file?

Yes, if it is stored in SharePoint or OneDrive, uses a modern format such as .xlsx, and AutoSave is on. Files on traditional network shares open for one editor at a time.