Excel in use gives wrong user name as one in workbook

Question

Hello Microsoft Team,

We are using Microsoft Excel 2019/Office 365 with Windows 10. As expected, when one person is in a Excel file on a network share drive, the read-only option pops up. The issue we are having is that the workbook will say it's locked by a user who is not actually in the workbook, but by another person (always the same person). It is then difficult to know who needs to exit out of the workbook to enable others to use it.

How do we fix this please, where Excel recognizes the correct user?

Answer 1

Step 1: Disconnect User Disconnect user who is associated with the locked file from the machine they are currently using. (Normally you get the username from the lock error pop-up) Step 2: Connect to your File Server's File ServicesGo to your file serve r– Right Click My computer – Click Manage – Expand Server Manager – Click Roles – Click File Services

Step 3: Click on Share and Storage managementClick on the Share and Storage management.

Step 4: Close open sessionsUnder the actions menu on the right Click on “Manages Sessions…” , look for any related open sessions and close all of them

Step 5: Close Open FilesUnder actions menu on the right Click on “Manages Open Files…” , look for any related open sessions and close all of them

Step 6: Open your fileAt this point you should be ok to open your shared file now to edit.

Reference:

How to clear a shared file that is locked on a domain network - Windows Server - Spiceworks

Answer 2

This action was done before and did not work.

Answer 3

Backup that file and remove that file on server and reupload that file.