Permission & Access Issues

How to Fix SharePoint Online Excel Files Locked by User

Rana Garcia Oct 1, 2026 869 views

Question details

Users are unable to edit SharePoint Online Excel files because the system incorrectly reports that the files are still locked by the user who previously opened them.

Fix SharePoint Online Excel Files Locked by the Opening User

Product: SharePoint Online / Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open and edit an Excel file hosted on a SharePoint Online document library.
Observed behavior: The Excel file is locked for editing, often by the same user trying to open it, even after it was previously closed. This prevents further modifications and collaborative editing.

Before you start

Before altering library settings, ensure that you have fully closed Microsoft Excel, signed out of Microsoft 365, and cleared your browser cache to rule out a simple hung session.

Solution 1Recommended

Disable Mandatory Checkout in SharePoint Library Settings

Files may appear locked if SharePoint is configured to require manual checkouts before editing. Disabling this allows seamless co-authoring.

SharePoint has a legacy feature that forces users to check out a document before making changes. While this prevents conflicts, it often results in locked file errors if a user forgets to check the file back in.

Open Library Settings

Navigate to your SharePoint document library, click the Settings (gear) icon in the top right, and select 'Library settings'.

Access More Library Settings

Click on 'More library settings' to open the advanced configuration page for the document library.

Go to Versioning Settings

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

Disable Checkout Requirement

Scroll down to 'Require documents to be checked out before they can be edited' and set it to 'No', then click 'OK' to save your changes.

Disable Mandatory Checkout in SharePoint Library Settings

Co-authoring enabled: Disabling the mandatory checkout requirement allows multiple users to co-author Excel files simultaneously without locking each other out.

Solution 2

Force Close Excel Processes and Clear Caches

A lingering background Excel process on your computer can maintain an active lock on the server.

Solution 3

Create a Service Request in Microsoft 365 Admin Center

If the issue persists across multiple users, files, and sites, it may indicate a backend SharePoint service or database problem.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are frustrated with SharePoint and Microsoft Excel synchronization and file locking issues, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for all your spreadsheet and document needs without the complex server-side locking headaches.

1. Download the Software: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installation file and follow the simple on-screen instructions to set up the software.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and drag-and-drop your Excel files into the interface to start editing seamlessly.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Avoids complicated server-side file lock issues with intuitive local and cloud file management.Lightweight design with fast startup times and minimal resource usage.Familiar user interface that requires zero learning curve for Office users.Built-in cloud storage for easy file sharing and real-time collaboration.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint say my Excel file is locked by me?

This usually happens when a previous session did not close properly, leaving a background process running or a temporary server lock active. It can also occur if mandatory check-out is enforced in the library settings and you forgot to check the file back in.

How long does a SharePoint lock last on an Excel file?

By default, a server lock on an Office file in SharePoint can last up to 10 minutes after an unexpected disconnection or crash. Waiting for this timeout period often resolves temporary lock issues.

Can an admin force unlock an Excel file in SharePoint Online?

Yes, an administrator can override a check-out by going to Library Settings, selecting 'Manage files which have no checked in version', taking ownership of the documents, and checking them in.

What are HAR logs and why does Microsoft Support need them for this issue?

HAR (HTTP Archive) logs record the network interaction between your web browser and the SharePoint server. Microsoft Support uses these logs to identify exactly where the communication fails and why the server isn't releasing the file lock.

Document & File Issues