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.