Unlock an Excel File Locked for Editing in OneDrive
Question details
The user needs to edit an Excel workbook in OneDrive or SharePoint that is locked by another user.

- 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.
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.
Ask the other user to close the Excel workbook
Use this approach when the person named in the lock message is available.
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.
Close any copies of the workbook you have open in Excel or in a browser, then allow time for the lock to clear.
Return to the file in OneDrive or SharePoint and select it to open it again. Check whether editing is now available.

Ask an administrator to investigate a persistent lock
Use this option if the user has closed the workbook but the lock remains.
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.

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.




