Office Settings & Configuration

Fix the Wrong User Name in an Excel Workbook Lock

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

The user wants Excel to show the correct person's name when an older workbook is locked.

Fix the Wrong User Name in an Excel Workbook Lock
Product
Microsoft Excel
Device & OS
Windows
Scenario
Workbooks are opened from a file server after the Office user name setting was changed.
Observed behavior
Recently created files show the correct name, but some older files still show a generic Windows user name in the lock message.
Before you start

Identify the affected workbooks and confirm who has them open. Check the Excel user name on the Windows account that opens the files, since changing another user's settings will not update their session.

Solution 1Recommended

Check the Excel user name and reopen the workbook

Use this first to verify the name associated with the Excel session that creates the lock.

1
Check the Office user name

On the computer that opens the workbook, select File > Options > General in Excel. Under Personalize your copy of Microsoft Office, check the User name field and enter the correct name if needed.

2
Close the workbook

Ask everyone to close the affected workbook, then close Excel on the computer that was using it.

3
Reopen and test

Reopen the workbook from the file server, then try opening it from another session to check the name shown in the lock message.

Check the Excel user name and reopen the workbook
Lock names and author names differ: Excel's lock message can be influenced by the opening user's environment and the temporary lock file. Changing workbook author metadata alone may not change the name in the lock message.
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. Its format compatibility makes it easy to move existing workbooks into WPS, although it does not fix Excel's lock-owner settings.

Open and edit workbooks in WPS SpreadsheetsCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why do new workbooks show the correct name while older ones do not?

The older files or their lock information may retain a previous generic value. Check File > Options > General on the computer opening the file, then test a newly saved copy of an affected workbook.

Does changing the workbook author change the lock owner?

Not necessarily. The author under File > Info is workbook metadata, while the lock message is associated with the session and lock information created when the workbook is opened.

Where can I change my Excel user name?

In Excel, select File > Options > General and look under Personalize your copy of Microsoft Office. Update the User name field on the account that opens the workbook.

Can I replace a workbook on the file server to test the fix?

Yes. First test a saved copy, then confirm everyone has closed the original before replacing it. In the reported case, copying files from the server and copying them back resolved the issue.