SharePoint Document Issues

How to Allow Only One User to Edit a SharePoint File at a Time

Maira Mehtab Sep 20, 2026 869 views

Question details

The user wants to configure a shared spreadsheet so that only one person can edit it at a time, forcing all other users to open the file in read-only mode.

Product: SharePoint
Device & OS: not provided
Scenario: Collaborating on shared files where simultaneous co-authoring causes conflicts or is undesirable for team workflow.
Observed behavior: By default, SharePoint allows co-authoring. The goal is to enforce exclusive editing rights (check-out) similar to a traditional file server.

Before you start

Ensure you have Site Owner or Full Control permissions for the SharePoint document library to modify its versioning and check-out settings.

Solution 1Recommended

Enable the 'Require Check Out' Feature in Library Settings

Configure your SharePoint document library to force users to check out files before editing, locking out other users.

SharePoint's check-out feature ensures that only one person can modify a document at a time. Note that this setting is applied at the document library level, meaning it will affect all files within that specific library, not just a single spreadsheet.

Open Document Library

Navigate to your SharePoint site and open the document library containing the file you want to restrict.

Access Library Settings

Click the Settings (gear icon) in the top right corner and select 'Library settings'. If you are using the modern SharePoint experience, click on 'More library settings'.

Open Versioning Settings

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

Require Check Out

Scroll down to the 'Require Check Out' section and select 'Yes' under 'Require documents to be checked out before they can be edited?'.

Save Changes

Click 'OK' to save your changes. Users must now check out a file to edit it, forcing it to be read-only for everyone else until checked back in.

Library-Level Setting: The check-out requirement applies to the entire document library. If you only want this rule for a specific file, consider moving that file to a dedicated restricted library.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Spreadsheets?

While SharePoint offers robust enterprise features, setting up file restrictions can be complex. WPS Office provides a free, lightweight, and highly compatible suite with built-in cloud collaboration tools for easier document management.

1. Download WPS Office: Visit the official WPS website and download the free installer.
2. Install the Software: Run the setup file and follow the on-screen instructions to install WPS Office on your device.
3. Open Your Files: Launch WPS Spreadsheets to seamlessly open, edit, and manage your existing Microsoft Office files.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats.Lightweight application that runs smoothly on Windows, Mac, and Linux.Familiar interface with no steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I require check-out for just one specific file instead of the whole library?

No, the 'Require Check Out' setting in SharePoint is configured at the document library level. If you need this restriction for a single file, you should create a separate document library specifically for that file.

How do users know if a file is checked out by someone else?

When a file is checked out, a small green arrow appears on the file's icon in SharePoint. If another user attempts to open it, they will receive a prompt stating the file is locked for editing and will only be able to view it in read-only mode.

What happens if a user forgets to check the file back in?

If a user leaves a file checked out, it remains locked for others. A site administrator or owner can manually override this by using the 'Discard Check Out' option in the file's context menu, which reverts any unsaved changes made by the user who locked it.

Document & File Issues