The library requires files to be checked in/out. When files open, in excel, it ask if the user wants to check the file out (or notifies them that the file is already checked out). All that works fine. The problem is that SOMETIMES, when closing the file, excel is NOT asking the user if they want to check the file in or save. The file simply closes and when someone else tries to open the file it says it is checked out and if the original user opens it, they can get errors when trying to save. Has anyone experienced this issue and if so any way to ensure when a file closes it prompts the user to check the file back in? Even if it simply does not save, but prompts to check back in, at least we could avoid record lock.
