Source: http://www.repairmsexcel.com/blog/solved-microsoft-excel-file-is-locked-for-editing-in-use-issue
How to Fix Microsoft Excel File locked for Editing?
In order to solve this issue, we will disconnect the user from the file and allow another user to get the complete accessibility, follow the below given step:
Step 1: First you have to note down the path to the file, and the file name.
Step 2: Open the run dialogue box, press the Windows Key + R from your keyboard to open up the Run dialog box.
Step 3: In the run dialogue box, type “mmc” and then hit the Enter key to open up the “Microsoft Management Console“.
Step 4: Choose the “File” > “Add/Remove Snap-in“.
Step 5: From the list of “Available snap-ins”, choose the “Shared Folders” and then choose “Add” to add it to the “Selected snap-ins” list.
Step 6: Another box will appear asking you to “Select the computer you want the snap-in to manage“. In case you are logged in on the server where the contaminated Excel file is present, then select “Local computer”. But if you are using a different system, then select the “Another computer”, then type the server where the Excel file stored.
Step 7: Now, in the view section, choose the “Open Files“.
Step 8: Choose the “OK“
Step 9: Click on the “Open Files” to expand it.
Step 10: You can sort the entire list according to your need and then search the file in the list. After it, right-click the file and, select “Close Open File”