Permission & Access Issues

How to Fix Excel Showing the Wrong User Has a File Open

Adam Davis Oct 9, 2026 868 views

Question details

The user is unable to edit a spreadsheet because the application incorrectly indicates that another specific user currently has the file open and locked.

How to Fix Excel Showing the Wrong User Has a File Open

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a workbook stored on a company shared network drive or SharePoint.
Observed behavior: Excel displays a prompt stating the file is locked for editing by an incorrect user or a stale session, preventing the current user from making changes.

Before you start

Verify with your colleagues that no one is genuinely actively editing the file on another workstation before attempting to forcefully clear the network lock.

Solution 1Recommended

Request IT Department to Disconnect the Stale Session

The most secure and direct method is to have an IT administrator identify and force-close the background server session holding the file lock.

When a file is hosted on a company shared drive, the network server manages file locks. If Excel crashes or network connectivity drops, the server might fail to release the lock, creating a 'stale' session.

Note the file details

Write down the exact network folder path of the locked Excel file and the name of the user that Excel claims has it open.

Contact IT support

Reach out to your company's IT helpdesk or system administrator and provide them with the file details.

Clear the server lock

Ask the administrator to use their server management tools (such as Shared Folders in Computer Management) to locate the open file and manually close the stale session.

Request IT Department to Disconnect the Stale Session

Server Permissions: Standard users typically do not have the necessary administrative privileges to view or close network server sessions directly.

Solution 2

Create a Copy of the Locked Workbook

If you need immediate access to edit the file and IT support is unavailable, you can bypass the lock by duplicating the workbook.

Solution 3

Release File Lock via SharePoint Administrator

If your workbook is stored on SharePoint rather than a local network drive, a site administrator can override the file lock.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Collaboration

Tired of dealing with frustrating file locks in Microsoft Excel? WPS Office provides a lightweight, highly compatible alternative for viewing and editing your important spreadsheets with robust cloud integration.

1. Download and Install: Visit the official WPS Office website and download the free installer for your operating system.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and directly open your existing Excel workbooks from your local drive or cloud storage.
3. Collaborate Effortlessly: Utilize WPS Cloud for real-time co-authoring without worrying about traditional server file locks.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsBuilt-in cloud collaboration tools that prevent stale network file locksLightweight software that installs quickly and runs smoothly on older devicesFamiliar user interface makes switching from Microsoft Office effortless

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel think another user has my file open when they do not?

This usually occurs due to a 'stale lock'. When a user opens a file on a network drive, the server locks it to prevent simultaneous edits. If Excel crashes, the computer loses network connection, or the user forces a shutdown without closing the file properly, the server may fail to release that lock.

Can I force unlock an Excel file on a shared drive myself?

Generally, no. Forcefully closing an open file session on a company shared drive requires server-level administrative privileges. You will typically need to ask your IT department to clear the session via the server management console.

How do I prevent stale file locks in the future?

To minimize stale locks, ensure you always close Excel properly using the 'Exit' or 'Close' buttons, completely save files before putting your computer to sleep or disconnecting from the VPN, and avoid leaving shared files open while you are away from your desk.

Document & File Issues