11

I'm opening an Excel file and I'm getting the File in use pop-up that says it's locked for editing by me. However, I've not got it open on this computer (I think I had it open and my machine blue-screened). How do I go about fixing this?

Should specify, this is a file on a file share.

edit I'm not talking about if this is being used by another user on another machine, this is only accessible by me on this file share.

enter image description here

3

1 Answer 1

19

Microsoft Office tracks those locks using files that are created in the same directory as the original file. The document Somedoc.docx gets a temporary lock file (Microsoft calls it an "owner file"): ~$Somedoc.docx. The same goes for Powerpoint and Excel. The owner of that file is the owner reported in the dialog.

enter image description here

The easiest way out is to delete that file. It is a hidden file, so you should set your Windows Explorer to view "protected operating system files":

  1. Open Folder Options by clicking the Start button, clicking Control Panel, click Appearance and Personalization, and then click Folder Options.
  2. Click the View tab.
  3. Under Advanced settings, click Show hidden files, folders, and drives,
  4. Un-Check Hide protected operating system files (Recommended), and then click OK.

enter image description here

You should see that file in the same directory the original file is in. Delete it and open the document again.

This situation is explained more elaborately here .

Not the answer you're looking for? Browse other questions tagged .