Permission & Access Issues

Unlock an Excel File Locked for Editing in OneDrive

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 868 views

Question details

The user needs to edit an Excel workbook in OneDrive or SharePoint that is locked by another user.

Unlock an Excel File Locked for Editing in OneDrive
Product
Microsoft Excel and OneDrive or SharePoint
Device & OS
not provided
Scenario
A shared workbook remains locked after another user has opened it for editing.
Observed behavior
Excel reports that the file is in use, and the owner may not have an option to forcibly end the other user's editing session.
Before you start

Check the File in use message for the name of the user holding the lock. Confirm whether the workbook is stored in OneDrive or a SharePoint document library so you can contact the right user or administrator.

Solution 1Recommended

Ask the other user to close the Excel workbook

Use this approach when the person named in the lock message is available.

1
Contact the named user

Ask the person shown in the File in use message to save their changes and close the workbook in Excel and any browser tabs where it is open.

2
Close your own copies

Close any copies of the workbook you have open in Excel or in a browser, then allow time for the lock to clear.

3
Reopen the workbook

Return to the file in OneDrive or SharePoint and select it to open it again. Check whether editing is now available.

Ask the other user to close the Excel workbook
A lock may not clear immediately: Closing the workbook does not always release its lock instantly. An owner may not have a direct control to forcibly terminate every active editing session.
Free Microsoft Office alternative

Edit Excel-Compatible Workbooks with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel-compatible workbooks. It supports a straightforward move to another office suite, but it does not forcibly release Microsoft OneDrive or SharePoint editing locks.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheets in a familiar interfaceUse a free, lightweight office suiteMove compatible documents between Microsoft Office and WPS Office
microsoft office alternative - wps office

Frequently Asked Questions

Can I force another user out of an Excel file in OneDrive?

A file owner may not have a direct option to terminate every active editing session. Ask the user named in the File in use message to save and close the workbook, then allow time for the lock to clear.

What if the user has already closed the workbook?

Ask the user to check for other open copies in Excel and browser tabs. Close your own copies, wait, and reopen the file from OneDrive or SharePoint.

Who can help if the Excel file stays locked?

Contact your Microsoft 365 or SharePoint administrator with the file location and the name in the lock message. They can investigate access, checkout status, and other available administrative options.

Does discarding a SharePoint checkout always clear an editing lock?

No. A checkout and an active editing lock are different conditions. An authorized administrator can check the document library for a checkout, but discarding it may remove unpublished changes.