Release Locked Files in Windows 10
The most common reason for the problem of locked files in a collaborating environment is due to the File being accessed by one of the shared users and left open overnight. As you must have realized, the easiest way to unlock locked files is to locate the computer where the file has been left open and simply close the file. If you are unable to get hold of the person that has left the file open, you should be able to unlock the locked file using steps as provided below.
1. Unlock File Locked by Another User
If you have Admin access to the network, you should be able to Unlock the Locked File using steps as provided below.
Press Windows + R keys to bring up the Run command or right-click on the Start button and click on RUN.
In Run Command window, type mmc and click on OK to bring up Microsoft Management Console.
On the next screen, click on File > Add/Remove Snap-in.
On “Add or Remove Snap-ins” screen, select Shared Folders and click on the Add button.
On the next screen, select Local Computer if you are logged into the computer or network where the file resides. If not, select Another computer and click on Browse.
Once the other computer is located, select Open Files option and click on the Finish button. 6. Back on “Add or Remove Snap-ins” screen, click on OK to Add the selected Snap-in.
- On the next screen, expand the list of Open Files > right-click on the Locked File and click on Close Open File option.
Once the open file is closed, the blocking user will be removed from the File and the File will become unlocked.
2. Unlock File Locked on your Computer
As mentioned above, Excel, Word and other Microsoft Office files can get locked, even if they are not being shared with other users. This happens due to the way Microsoft Office creates a temporary ownership file whenever a Microsoft Office File is opened and automatically deletes the temporary ownership file as soon as the File is closed. If the file does not close properly, the temporary ownership file remains open in the memory, leading to “File is Locked for Editing by another user” error. The only way to fix this issue is to locate the temporary ownership file on your computer and delete the ownership file.
Right-click on the Start button and click on File Explorer.
On File Explorer screen, navigate to the Location of the temporary ownership file ~$
and delete this file. For example, if the file is example.xls, the temporary ownership file will be named as ~$example.com. Once the temporary ownership file is deleted, you will be able to open/edit your Excel File, without encountering “File is Locked for editing by another user” message.
How to Fix Microsoft Excel Not Responding Error in Windows 10 How to Change Ownership of File or Folder in Windows 10
