Friday 9 November 2018

microsoft office - How do I stop the excel file being in use?



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



Answer



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 .


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...