SharePoint Document Issues

Fix SharePoint Excel File Locked When Multiple Users Edit

Olivia MillerOlivia Miller Oct 22, 2026 871 views

Question details

Users experience a 'File in Use' or locking error when multiple owners attempt to co-author an Excel file stored in SharePoint.

How to Fix SharePoint Excel File Locked During Co-Authoring
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.
Before you start

Ensure that you have sufficient administrative or owner permissions in the SharePoint site to modify document library settings and manage file check-outs.

Solution 1Recommended

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.

1
Access Library Settings

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'.

2
Open Versioning Settings

Under the General Settings column, click on the 'Versioning settings' link.

3
Disable Required Check-Out

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.

Setting Updated: Once disabled, multiple users will be able to click on the file and co-author simultaneously without locking the document.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Enjoy real-time co-authoring through WPS Cloud without complex check-out settings.Lightweight application that runs smoothly on older devices and consumes minimal system resources.Free to use with an intuitive, familiar tabbed interface for seamless migration.
microsoft office alternative - wps office

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.