Locked by another user error

ramana53

New Member
Joined
Aug 15, 2019
Messages
4
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.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Sam_D_Ben

Active Member
Joined
Oct 17, 2012
Messages
379
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”

q7MmS6t.png


Hope this helps.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,437
Messages
5,596,120
Members
414,043
Latest member
thomas Stein

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top