If you have a user reporting the error message stating that file is locked by the wrong user in excel, that's because there may be a corrupted temp file for excel. Please do the following to solve this issue.


  1. Open the folder where the Document is located.
  2. Click Tools=>Folder Options
  3. Click the View tab
  4. Scoll down to Advanced Settings>Hidden files and folders
  5. Select Show hidden files and folders and Unselect Hide protected operating system files
  6. Look for a temp lock file and delete it. It should look something like ~$filename.xlsx  or whatever file extension the it was saved in.
    (In my case, this file had become corrupt and was stuck displaying an earlier modify date from a few days ago..)



https://social.technet.microsoft.com/Forums/office/en-US/2586a8cb-3452-422e-bf16-f6782beb0423/excel-reporting-wrong-user-editing-it-under-file-locking?forum=excel