Forum Discussion
File locked for editing - always same person
We have a workbook that is worked in by multiple people. When the file is opened by someone else and you try opening it, it prevents you from opening it in edit mode - just like it should. The pr...
Okay, so I solved this today.
Apparently it had to do with a corrupted temp file related to the workbook.
All that needed to be done was to go into the folder view options, unchecking"Hide protected operating system files" and then removing the '~$FileName.xlsm' file. This also seems to have sped up the process of opening the workbook :)