Permission & Access Issues

Fix Excel Showing the Wrong User for a Locked Network Workbook

John Wilson Oct 22, 2026 868 views

Question details

Excel incorrectly identifies the account name of the user who has a network workbook locked for editing.

Fix Excel Showing the Wrong User for a Locked Network Workbook

Product: Microsoft Excel 2019 and Microsoft 365
Device & OS: not provided
Scenario: Multiple users are trying to access a shared workbook stored on a network share.
Observed behavior: Excel displays a read-only notification indicating the file is locked, but it always shows the same incorrect user account instead of the person actually editing it.

Before you start

Ensure you have administrative access to the file server hosting the network share, and verify that no users are actively trying to save the workbook.

Solution 1Recommended

Clear Stale Sessions and Open Handles via Server Manager

Use Server Manager on your file server to manually close lingering file sessions that are causing the incorrect lock notification.

This issue typically occurs because the file server retains a stale session or an open file handle associated with a user whose connection dropped unexpectedly.

Access Server Manager

Navigate to Share and Storage Management

Go to File Services, then click on Share and Storage Management from the available administrative tools.

Manage and Close Sessions

Click on 'Manage Sessions'. Locate the session associated with the incorrectly identified user or the specific workbook, select it, and close the session.

Manage Open Files

Next, click on 'Manage Open Files'. Find any remaining open handles for the locked Excel workbook and close them to completely release the file lock.

Clear Stale Sessions and Open Handles via Server Manager

Server Backup Precaution: Always back up the locked file before forcing server-side session closures to prevent accidental data loss.

Solution 2

Replace the Workbook on the Server

If clearing sessions is ineffective, replacing the locked file with a backup can reset network share permissions and locks.

Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

Tired of complicated network file-locking issues? WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office, featuring robust cloud collaboration that eliminates traditional network drive file conflicts.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
2. Open Your Network Workbook: Launch WPS Spreadsheets and seamlessly open your existing .xlsx files directly from your local drive or network share.
3. Collaborate via WPS Cloud: Upload the file to WPS Cloud to enable real-time co-authoring, completely bypassing SMB network file lock issues.

Highly compatible with Microsoft Excel (.xlsx) formatsBuilt-in cloud collaboration prevents traditional file-locking conflictsLightweight application that runs smoothly on older devicesFamiliar user interface for a seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a user who is not currently logged in as locking a file?

This happens when a user's previous session disconnected abruptly (e.g., due to a network drop or crash) and the Windows Server failed to release the SMB file handle, resulting in a 'stale' session.

Can I unlock the Excel file without administrative access to the server?

Generally, no. If the file handle is locked at the server level, an administrator must clear the session. As a temporary workaround, you can open the file in read-only mode and use 'Save As' to create a new, editable copy.

How do I prevent network files from locking incorrectly in the future?

Ensuring stable network connections for all users helps. Alternatively, migrating from traditional network shares to cloud-based co-authoring platforms (like WPS Cloud or SharePoint) eliminates traditional SMB locking conflicts.

Document & File Issues