In Run Command window, type mmc and click on OK to bring up Microsoft Management Console.Ĥ.
SHARED EXCEL FILE LOCKED FOR EDITING WINDOWS
Note: You can also press Windows + R keys to bring up the Run command.ģ. Right-click on the Start button and click on RUN. Note down the File Name and the Path to the Excel File.Ģ. Note: You need to have Admin access to the server where the Excel file resides, in order to be able to remotely close open files on a network.ġ.
However, if the other User has left the File open and is currently unavailable, you can follow the steps below to remotely close the file. If you are getting “File is Locked for Editing by another user” message in case of a Shared File, you can ask the other User to close the File or use the co-authoring feature in Excel. Shared Excel File is Locked for Editing By Another User Once you delete the temporary ownership file, you will be able to open/edit your Excel File, without encountering “File is Locked for editing by another user” message. On the File Explorer screen, navigate to the location of the temporary ownership file having name ~$ and delete this file.įor example, if the Excel file that you want to open/Edit is example.xls, you will find a temporary ownership file having the name ~$. Right-click on the Start button and click on File Explorer.Ģ. The fix for this issue is to locate and delete the temporary ownership file from your computer.ġ. However, sometimes the file does not close properly and the temporary ownership file remains in the memory, leading to “File in Use and File is Locked for editing” error in Excel. When you open an Excel file, Microsoft Office creates a temporary ownership file and automatically deletes this file as soon as you close the Excel File. Excel File is Locked for Editing By Another User – Single Owner Case So, let us go ahead and take a look at the steps to fix “File is Locked for Editing by another use” error, both in Shared and Single owner cases. Sometimes you just see the read only message but that can vary from user to user.If you are not sharing the file with anyone and still see “File is Locked for editing by another user” error message, you yourself are the other user. You should see who is locking the file if other users keep trying to open/save it in Excel. In control panel, delete stored credentials for Office 365.Click on “Check out”, then immediately go back and click on “Check in”.Ask them to launch Excel and click on File > Info > Manage Workbook.Ask them to launch Excel and open the file then close it.Determine which user account is reporting as having the file locked.This should allow SharePoint to release the lock.
Do not attempt to reopen the file Excel and Excel Online for 30 minutes.Attempt to resolve the issue in the Upload Center or discard the file in the queue.On each machine they use, launch the Upload Center and check that none of them are showing pending or failed uploads, specifically for that file.Get all users who collaborate on the file to close it, both in Excel and Excel Online.It appears to happen when saving the file and the users Upload Center is having authentication issues. I saw this in Word live collaboration only last week but it also occurs in Excel.