Fix the Wrong User Name in an Excel Workbook Lock
Question details
The user wants Excel to show the correct person's name when an older workbook is locked.

- 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.
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.
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.
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.
Ask everyone to close the affected workbook, then close Excel on the computer that was using it.
Reopen the workbook from the file server, then try opening it from another session to check the name shown in the lock message.

Recreate an affected workbook copy
Try a new copy when the correct user name appears for new workbooks but an older file still shows the generic name.
Update the workbook's author property
Use this to correct the author shown in workbook properties, separately from the lock message.
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.

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.




