We have an Excel file that is on our network that one person usually keeps open and makes changes to. Other users keep the file open, in read-only mode.
Occasionally, someone other than the first person who is in charge of editing the excel file will open that file and somehow take over write functionality of that file causing the person who is supposed to make edits unable to save those changes.
This has been occuring for quite some time and I can't seem to find a fix for it.
Any ideas what's going on?
Windows 7 Pro x64