SharePoint Document Issues

How to Fix SharePoint Saying an Excel File Is Open in Another Application

Maira Mehtab Sep 21, 2026 871 views

Question details

The user is experiencing a recurring issue where SharePoint incorrectly reports an Excel file is already open in another application when trying to access it via the desktop app.

Product: Microsoft Excel / SharePoint
Device & OS: not provided
Scenario: Opening a shared Excel document from SharePoint in the Excel desktop application.
Observed behavior: SharePoint displays a false prompt stating the file is open in another application, blocking access despite no one actively having the file open. Temporary workarounds like re-uploading fail to permanently resolve it.

Before you start

Ensure that all users who previously accessed the file have completely closed their Excel desktop applications and check your internet connection to rule out syncing delays.

Solution 1Recommended

Open the File Directly from the Excel Desktop App

Bypassing the SharePoint web interface can sometimes resolve file-locking conflicts caused by browser handoffs.

Launch Excel

Open your Microsoft Excel desktop application from your computer.

Navigate to Open

Click on 'File' in the top left corner of the Excel window, then select 'Open' from the left sidebar.

Select SharePoint Site

Choose your connected SharePoint or OneDrive location from the list of available services under 'Other Web Locations'.

Open the File

Browse to the specific Excel file and open it directly from within the app to see if the lock prompt still appears.

Solution 2

Determine if the Lock is File-Specific or Account-Wide

Identifying whether the issue is isolated to a single file or a broader synchronization issue helps pinpoint the exact cause of the lock.

Solution 3

Troubleshoot OneDrive Sync and Office Cache

Syncing issues between SharePoint, OneDrive, and the Office Upload Center often cause ghost locks on shared documents.

Free Microsoft Office alternative

Edit Excel Files Seamlessly with WPS Office

If Microsoft Office and SharePoint file locks are disrupting your daily workflow, consider trying WPS Office. It provides a lightweight, highly compatible alternative that handles your spreadsheets smoothly without the frequent sync-lock headaches.

1. Download and Install: Download WPS Office from the official website and follow the installation wizard.
2. Launch WPS Spreadsheet: Open the application and select the 'Spreadsheet' module from the home screen.
3. Edit Without Limitations: Open your downloaded Excel document to edit and save it without encountering false file lock errors.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Avoids complex SharePoint synchronization locks by supporting straightforward local and cloud editing.Lightweight installation with extremely fast startup times.Familiar user interface for a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint say my Excel file is open when it isn't?

This usually happens due to a delay in SharePoint releasing the file lock after a user closes it, or a synchronization glitch between the Office desktop client and the OneDrive sync engine.

Can I force unlock an Excel file in SharePoint?

Yes, a SharePoint administrator can force unlock a document by navigating to the site settings and managing the active file sessions, or by checking the file out and then checking it back in.

Does clearing the browser cache fix SharePoint file locks?

Clearing the browser cache rarely fixes desktop app file locks. However, clearing your Office Document Cache and Windows Credentials is much more effective for resolving persistent session locks.

How long does a SharePoint file lock last if someone abruptly disconnects?

If a user closes a file abruptly or loses internet connection without saving properly, the SharePoint server may retain the lock for about 10 to 15 minutes before automatically releasing it.

Document & File Issues