I have a file that is shared on our company drive. You can open it up and have another file open, but if you close the file and try and open it up again it will not open up until you close all other excel files and double click it again. This is a problem because some people use it multiple times in a day, but only one person can be in it at a time so they close out of it after. It for some reason locks the file from editing saying someone is in it. Even though it is closed on the persons computer who just used it. I am pretty stumped, I have checked all my macros and none of them would cause this interaction. It appears to not release the lock until the person who last used it closes out of all of their excel files.
Update: Even though said file is closed when you close the other excel files it asks if you want to save the closed file. It is like it is hooking into the other files.
Bookmarks