So, if you'd like to benefit from any of the above options, be sure to apply them before sharing your Excel file. User Alert System provided by - Copyright © 2019 DragonByte Technologies Ltd. Is there anyway then to open the file or to reduce its size without opening it through magics. As such, it could quite easily be any old rubbish. How can I stop this from happening? There's a possible answer at: In summary: If the file is on a drive mapped by group policy, the periodic policy refresh can disconnect and reconnect the drive, causing the lock to vanish.
The macro runs as soon as the file is opened. Edit: Please ensure that you are not doing anything important on Excel files and if you are doing so then please save your work prior to performing the steps mentioned above. Check the following link for details: I've been having this issue on one of my Windows networks and finally took the time to figure it out. This is a file on a network share. In my case, it wasn't nearly as complicated as some related threads might indicate. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly. So it says it is locked by himself.
We have a large 4,000+ rows excel worksheet from a prior employee that I would like to be able to use, but it is password protected and no one has the password. I even thought perhaps I didn't save it as often as I thought, I know that I did but I remembered that I saved it at least once and I can't even find an Excel file that has been modified since Thurs!!! Doing this immediately fixed our problem. And even after editing, saving and closing Excel, that hidden file is still not deleted. The app server doesn't seem to come into the equation, but file server 2 does not exhibit the same issues as file server 1. Thanks mmwest Hi, Could you give me more det ai l information? It would save me a couple days of work if it is possible. The problem was that Excel tells the second user that it's 'another user' rather than reporting the first user's actual name, making it difficult to work out who has it open.
There are Office patches which claim to resolve this issue at the workstation level, but deleting the temporary file is the most efficient workaround. Then uncheck Refresh data when opening file. But none of suggestions helped. From , Unlocker is a tool that can trace and unlock the locking protection commonly used in files on Microsoft Windows. We are currently investigating this further and will post more information as it is available. Hi, sorry if this has already been asked. On the other hand, if I have to continue using Excel 2007 which is indefensibly rubbish if you ask me and this keeps happening I'll probably defenestrate my computer anyway, with the same end result.
If one user edits the file, the temporary files will create in the same shared file directory by default. From the window that opens, choose Change preferences bottom left. I am trying this on his workstation and mine. I saved it routinely as I was making many changes updates etc. Now, is there anything I can do on his workstation to unlock this file? Understand that these fixes don't make the File in Use dialog go away, they just correct the problem of showing bogus user name information on the dialog itself. You may not see other people's selections if you are using a version other than Excel 2016 for Office 365 or Excel Online. The problem here may have something to do with the Windows Explorer in Windows 7.
The detailed steps on how to do this can be found. Now, I need to share this macro with some other people, so basically I've just sent that excel file on to the people that need to use it. While fast and convenient, the former method created multiple versions of the same document, and the latter produced a secure though non-editable copy. Feedback Buttons provided by - Copyright © 2019 DragonByte Technologies Ltd. On unticking it the problem has gone away. If that's what you want, click Yes, otherwise No.
When I open it I do not get the file is locked for editting message nor does a second user. Can anyone help me find those hidden files to delete? You have disconnected the user who had the file open and unlocked it. Thanks for contributing an answer to Server Fault! We have used this spreadsheet for 9 years without an issue until now. Need some relieve since I am developing a system for a non-profit organization. On the File menu, click Exit Task Manager. Uncheck 'Details Pane' and 'Preview Pane' I found that the user that was having the problem and cuasing the others problems had the 5.
Did you use a share Excel ,word or notepad across the network? Open the share and see if there are any file locks. It is also available to others as 'read only' When someone who is read only forgets they have it in their open files, no one who needs to make changes can get in to make changes. So I removed the form control buttons and created new ActiveX command buttons. Clicking save just invokes the same msgbox again. Provide details and share your research! In our case the first user with the file open is on Excel 2007; the second user is on Excel 2010; perhaps there's some incompatibility which causes the second user's Excel to be unable to get the real name.