Fix SharePoint Excel File Locked When Multiple Users Edit
Question details
Users experience a 'File in Use' or locking error when multiple owners attempt to co-author an Excel file stored in SharePoint.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Simultaneous editing (co-authoring) of a shared Excel workbook in SharePoint.
- Observed behavior
- The Excel file becomes locked and displays a 'File in Use' message instead of allowing multiple users to edit the document at the same time.
Ensure that you have sufficient administrative or owner permissions in the SharePoint site to modify document library settings and manage file check-outs.
Disable Required Check-Out in SharePoint Library
If SharePoint requires documents to be checked out before editing, co-authoring is automatically disabled. Turning this setting off allows simultaneous edits.
When 'Require Check Out' is enabled, only one person can edit the document at a time, locking out all other users until the file is checked back in.
Navigate to the SharePoint document library where your Excel file is stored. Click the gear icon in the top right corner, select 'Library settings', and then click 'More library settings'.
Under the General Settings column, click on the 'Versioning settings' link.
Scroll to the bottom of the page to the 'Require Check Out' section. Select 'No' for 'Require documents to be checked out before they can be edited?' and click OK to save your changes.
Ensure Compatible File Format and Permissions
Co-authoring requires modern Excel file formats and the correct editing permissions for all participating users.
Force Check-In a Locked File
Sometimes a file remains locked because another user checked it out and forgot to check it back in or close their session.
Use WPS Office for Seamless Spreadsheet Collaboration
Experiencing sync and locking issues with Microsoft Excel and SharePoint? WPS Office provides a highly compatible, lightweight, and free alternative with smooth real-time co-authoring capabilities.

Frequently Asked Questions
Why does my Excel file in SharePoint say 'File in Use'?
This usually happens if someone has the file checked out, if the SharePoint library requires check-out for editing, or if a user has opened the file in an older desktop version of Excel that does not support modern co-authoring.
Can multiple users edit an older .xls file in SharePoint simultaneously?
No, older Excel formats like .xls do not support real-time co-authoring. You must open the file and convert the workbook to the modern .xlsx format to allow multiple users to edit at the same time.
How do I see who has the Excel file locked in SharePoint?
Hover over the file in the SharePoint document library. If it is checked out, a tooltip will usually display the name of the user who has it locked. Alternatively, the 'File in Use' prompt in Excel will often state which user currently has the file open.




