Re: Excel Locked for Editing by Me this happens to me pretty much every time i open a file after upgrading to 2010. I usually just click 'Notify' on the popup and within a few seconds excel says the file is available for editing. May 23, 2016. Getting the message 'File in use - File is locked for editing by another user. Open 'read only'.' After closing my excel file and re-opening it.
Patrick, I have a NetApp as well and I have also been able to unlock files using Computer Management. Note: The domain login you are using on the computer you are performing this from may need to have proper permissions over the filer in order to do this. If you're using Windows, launch compmgmt.msc and then right-click on Computer Management (Local Computer) at the top of the tree and Connect to Another Computer. Type in the hostname or IP address of the NetApp filer that hosts your CIFS share. Expand System Tools. Be patient, it could take a minute or two. Then expand Share Folders and go to Open Files.
A list of open files and their network users should populate the list to the right. This has worked for me when working with both Windows file servers and NetApp filers. Should also work for EMC or IBM System X, to my knowledge. Hope this helps. Patrick, I have a NetApp as well and I have also been able to unlock files using Computer Management.
Note: The domain login you are using on the computer you are performing this from may need to have proper permissions over the filer in order to do this. If you're using Windows, launch compmgmt.msc and then right-click on Computer Management (Local Computer) at the top of the tree and Connect to Another Computer. Type in the hostname or IP address of the NetApp filer that hosts your CIFS share. Expand System Tools.
Be patient, it could take a minute or two. Then expand Share Folders and go to Open Files. A list of open files and their network users should populate the list to the right. This has worked for me when working with both Windows file servers and NetApp filers. Should also work for EMC or IBM System X, to my knowledge. Hope this helps. Just another note for people finding this, I have a 2008 AD setup and just ran into the same issue with a twist.
The file is a commonly used file on our network. It is on the file server and there is not a temp file (as stated you need to change the default view options so you see hidden, system files and the like to really SEE all the files). Again, the server sees it as open and no temp file is there. I went into Control Panel Administrator Tools Share and Storage Management Manage Open Files (on the far right). The user that supposedly had it open did not. However another user did have it open. They closed it and all is well.
I did not force it closed but that is an option. I only have guesses as to why that is happening; I don't know for sure. KadduK wrote: The files are on a server and I don't think there is any lock on the files. So the user is loggin into the server's desktop then opening up the file? I think they are on the server and it is acting as a file share - check the server for open files in the computer management snap in - as stated in the best answer of this thread. KadduK wrote: I tried checking for the hidden files in the 'Temporary Internet Files Content.IE5'.
![Unlock Unlock](/uploads/1/2/5/6/125657317/526894822.jpg)
Does not show any. So it is located on a server and you are checking the IE temp files? I just realized this thread was answered and you are having this same problem - probably should have started a new thread and referenced this one as a similar issue (but not the same as you have already tried it right)?
We’ve had several calls recently about newmisserver files being “locked for editing”, although no one has them open at the time. Here’s what’s up and how you can fix it. How Word and Excel Handle Files on the Server If you open a Word or Excel file on the server it could potentially be in use by another person at the same time. There could be a problem with that, because if your colleague saves their changes and then you later change yours, you’ve just overwritten your colleague’s changes. That doesn’t make for good office relationships! As a safeguard, Excel and Word create a temporary “ownership file” in the location of the document, giving it the name “$” followed by the name of the document. For instance, if you were opening the file “myfile.doc” on newmisserver public, an ownership file named “$myfile.doc” would also be created on newmisserver public.
The file contains the name of the person editing the document. This file would be visible if you looked for it on newmisserver public from a PC, but on a Mac it’s invisible. When you close the document or quit the application, Word and Excel delete the ownership file.
If you try to open a file that has an existing ownership file, you get a message that the file is locked for editing. What Sometimes Goes Wrong This is a good scheme, as long as the document is closed normally and Word or Excel gets the chance to delete that file. If, however, Word or Excel crash or the connection to the network is interrupted, the ownership file may not be deleted. Sometimes a network connection may be disrupted manually–if you pull the Ethernet cable out of the computer, say, without first closing the file and disconnecting from newmisserver; sometimes there may be a glitch in the network, causing a temporary disconnection at just the wrong moment. Whatever the cause, in these cases the ownership file is left behind, and no one is able to open the file for editing.
How to Fix It If this happens to a file you’re trying to access, it’s easy to fix: First, double check with your colleagues that they don’t actually have the file open. If no one has the file open, on a PC (not a Mac), open up “My Computer” (Windows XP) or “Computer” (Windows 7). Navigate to the newmisserver folder where the document is stored.
Find the errant ownership file, which starts with “$” and has the name of your document. An easy way to do this is to use Details listing format and order the files by Name–it will pop to the top of the list. Delete the file. Now you should be able to open the file for editing without any problem. Posted in Post navigation.