Permission & Access Issues

How to Fix the Wrong User in Excel 'Locked for Editing' Message

John WilsonJohn Wilson Oct 29, 2026 871 views

Question details

Users need to clear the incorrect user name displayed in the file lock prompt when opening a shared Excel workbook.

How to Fix the Wrong User in Excel's 'Locked for Editing' Message
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a shared Excel file located on a network drive or shared collaborative folder.
Observed behavior
Excel displays a 'Locked for editing' message that shows the name of an incorrect user, such as a former employee, rather than the person currently accessing the file.
Before you start

Verify that all active users have saved and closed the shared workbook. You may also need administrative privileges to view and delete files in the shared network folder.

Solution 1Recommended

Clear Stale Hidden Temporary (.TMP) Files

Remove outdated temporary lock files in the shared folder that are retaining old user information and causing the false locked message.

When an Excel file is opened on a shared drive, the system creates a hidden temporary file (owner file) to lock the document and record who is editing it. If Excel crashes or the network disconnects, this file might not be deleted automatically, leading to a stale lock that displays the previous user's name.

1
Enable Hidden Items in File Explorer

Open Windows File Explorer, click on the 'View' tab at the top of the window, and check the box for 'Hidden items' in the Show/hide group.

2
Navigate to the Shared Folder

Go to the network directory or shared folder where the problematic Excel workbook is saved.

3
Locate and Delete Obsolete Lock Files

Look for hidden temporary files in the same directory. These files typically start with '~$', end with '.tmp', or share the same name as the workbook. Select the obsolete lock files and press Delete.

4
Test the Workbook

Double-click the Excel workbook to open it. Verify that the 'Locked for editing' prompt no longer appears or now accurately reflects the current user.

Clear Stale Hidden Temporary (.TMP) Files
Consult Your Administrator: Contact your IT administrator before deleting files in a shared network location to ensure you do not accidentally remove active system files or lack the necessary permissions.
Real-Time Collaboration

Use WPS Office for Seamless Cloud Co-Editing

Avoid outdated file lock messages and local file conflicts by migrating your shared workbooks to WPS Office. With WPS Cloud, multiple users can collaborate on the same spreadsheet in real time without relying on fragile temporary lock files.

  1. 1. Download and Install WPS Office: Get WPS Office Free from the official website and complete the installation on your computer.
  2. 2. Upload the Workbook to WPS Cloud: Open WPS Office, navigate to the 'Cloud' tab on the left panel, and upload your shared Excel workbook.
  3. 3. Share with Your Team: Open the uploaded file and click the 'Share' button in the top right corner to generate a secure editing link for your colleagues.
  4. 4. Co-edit Simultaneously: Have your team open the shared link. Everyone can edit the document concurrently, completely bypassing traditional 'Locked for editing' issues.
Real-time multi-user co-editing without locked file errorsFully compatible with Microsoft Excel (.xlsx, .xls) formatsCloud synchronization prevents local hidden file conflictsLightweight, fast, and free to use
QA img-9

Frequently Asked Questions

Why does Excel show a former employee's name in the locked file prompt?

This happens when a hidden temporary 'owner' file, created when that employee last opened the document, was not automatically deleted when they closed it. This is usually caused by a software crash or network interruption.

How can I find out who is actually locking the Excel file on a network?

If clearing temporary files doesn't work, ask your IT administrator to check the server's 'Open Files' management console. This administrative tool shows exactly which user currently has the file open on the server level.

How do I prevent stale lock files from occurring in the future?

Ensure all users properly save and close their files before disconnecting from the network or putting their computers to sleep. Alternatively, transition to modern cloud-based co-authoring tools like WPS Cloud that do not rely on local temporary lock files.