My only solution is to open as read only and save changes as a different file name. When I go back and try to open the file it says its 'locked for editing' by me, even though I obviously know I do not have the file open.
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.Click the Tools menu, select Protect Document, and then click Sheet to unlock the spreadsheet.
Navigate to the folder on the shared drive where the file is locked. Open the Excel file containing the protected worksheet.the Select locked cells and Select unlocked cells options when protecting the.
To do this, open up file explorer and select the View tab and select "Hidden Items". Supposing, you receive an Excel file from another person which with. I have a shared excel doc that two users on my Windows 2000 LAN need to access at the same time. Temporarily turn on hidden files and folders.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. 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.