Locked by another user error

[ramana53]

User open the excel and it gives the error message locked by another user however no one has it open .How to resolve the issue.

 

[Sam_D_Ben]

In order to solve this issue, first 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”

Hope this helps.

 

[FormR]

Hi, more options to try here;

https://blogs.technet.microsoft.com...e-definitive-locked-file-post-updated-772014/

Turning off the preview pane and details pane in windows explorer has worked for me in the past.