File Sharing Problems

Fix Excel File Locked for Editing by Administrator Instead of User

Algirdas Jasaitis Oct 1, 2026 868 views

Question details

A shared Excel workbook on a network drive displays 'Administrator' as the person locking the file instead of the actual user's name.

How to Fix Excel File Locked for Editing by Administrator Instead of the User

Product: Microsoft Excel (Office LTSC 2021)
Device & OS: Windows 11
Scenario: Accessing a shared workbook over a local network after deploying new desktop computers.
Observed behavior: When another user opens the file, the lock prompt incorrectly identifies the editor as 'Administrator', making it impossible to know which colleague currently has the file open.

Before you start

Verify with your team if anyone is currently editing the file, and ask them to save and close it temporarily to ensure this isn't a stuck temporary file issue before changing network settings.

Solution 1Recommended

Verify Windows Credentials and Network Paths

Ensure that users are not unintentionally connecting to the network share using a shared administrator credential or inconsistent drive mappings.

Excel retrieves the editing name from the file-sharing mechanism. If a user's Windows Credential Manager has stored the server's 'Administrator' account to access the mapped drive, Excel will broadcast that name.

Open Windows Credential Manager

Click the Start button, type 'Credential Manager', and press Enter to open the utility.

Check Windows Credentials

Select 'Windows Credentials' and look for any saved credentials matching your file server's IP address or hostname.

Remove Incorrect Credentials

If you see an Administrator account listed for the server, click it and select 'Remove'. Restart the computer and map the drive using the user's specific account.

Standardize Network Paths

Ensure all users are opening the Excel file using the exact same path (e.g., all using the UNC path \\server\share\file.xlsx or all using the same mapped drive letter).

Verify Windows Credentials and Network Paths

Consistent Paths: Using identical UNC paths across all workstations often resolves file-locking identity conflicts.

Solution 2

Review Server and Office Identity Settings

Network administrators should verify the SMB configuration, share permissions, and Office registry settings on the newly deployed computers.

Solution 3

Clear Stuck Temporary Owner Files

Delete the hidden temporary file that Excel creates to track who is editing the workbook, which may be stuck on an old 'Administrator' lock.

Free Microsoft Office alternative

Avoid Network Locking Issues with WPS Office

If persistent SMB network locking and credential issues are disrupting your workflow, consider trying WPS Office. As a lightweight, highly compatible alternative to Microsoft Office, WPS Office offers powerful spreadsheet capabilities and built-in cloud collaboration tools that bypass local network locking headaches entirely.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your PC.
2. Open Your Excel File: Launch WPS Spreadsheet and click 'Open' to load your existing .xlsx network files seamlessly.
3. Collaborate in the Cloud: Upload your file to WPS Cloud to enable real-time co-editing, bypassing SMB Administrator locking issues entirely.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in cloud co-editing eliminates legacy local network file locking errors.Lightweight installation and free to use for daily spreadsheet tasks.Familiar user interface requires no retraining for your team.

microsoft office alternative - wps office

Frequently Asked Questions

Why did the displayed lock name change to Administrator after installing new Windows 11 computers?

This usually happens because the newly deployed computers were set up with default network drive mappings or credential setups that accidentally authenticate to the file server using a generic Administrator account instead of the logged-in user's credentials.

Will copying the locked Excel file fix the Administrator name issue?

No. Copying the file only creates a separate, unlocked version so you can edit the data. It does not fix the underlying network authentication or credential issue that is causing the file server to identify users as the Administrator.

How does Excel determine who is locking a file on a network share?

Excel determines the lock owner based on the Office account signed into the application or the Windows user credentials provided to the file-sharing protocol (SMB) when connecting to the network drive.

Document & File Issues