If you or your IT person are not able to close the file, please contact the ITS Help Desk with a complete path to the file.The new user who wants to edit the file now will be able to exit Excel, then re-open the file to edit it. That’s it You have disconnected the user who had the file open and unlocked it. Delete the file once you have verified that the owner of the file does not have it open. Find the file in the list, then right-click the file and choose Close Open File.When I try to delete the same file form SharePoint in my Edge browser, it says it is locked by me. Once you know the owner name, contact that person and double check that they do not have the file open. Now when I try to delete the file from the library I get file locked by another user. At the top there will be an Owner listed. To open a read-only copy of his document, click Document is locked for editing by yourself or opens as read only. If the Excel file contains more than one worksheet, The document file name is locked for editing by another user. Answer (1 of 3): According to Microsoft locked for editing only occurs when Excel previously quit improperly and, therefore, did not delete the owner file OR a second instance of Excel is running in the background with the document already open OR the document is shared over a network, and anot.
#Unlocking an excel file locked for editing how to
Select the Security Tab and click on Advanced. How to Lock & Unlock an Excel Spreadsheet Use a password to protect a locked worksheet from editing.
If it is more than a few days old, you are probably safe to delete it. You will now see a file with the same name that has a tilde (~) character in front of the file name.Navigate to the folder on the shared drive where the file is locked.To do this, open up file explorer and select the View tab and select "Hidden Items". Temporarily turn on hidden files and folders.
That’s how you can unlock an Excel spreadsheet with the password for the editing purpose. In the end, enter the password to the unlock Excel sheet.
Generally what happens is that the last person using the file got disconnected or did not get logged out correctly and a "hidden" file gets left behind - holding the file open. To unlock an Excel worksheet, open the file, click the Review button, and then select Protect Workbook. Occasionally, you might get an error when trying to open an Excel file on a Shared Drive that says "someone has this file open" and it will not let you open or edit the file.