We have Excel work books shared on a SBS 2003. The shared files will intermittently not allow any editing. They were originally created with Excel 2003, but have all been upgraded to Excel 2007.
The problem is that every now and then, when a user has to edit and modify the file it will come up and say “the file is locked for editing” and will not allow the user to modify the file. Yet, if they close the file, re-open it a short while later, they can modify the file.
We have checked all the permissions within the folder, checked if the file is open by another user and the other obvious scenarios, but no luck.
The confusing part is that this problem is intermittent, and will go for a couple of weeks with no problem, but every now and then, the file comes up and will not allow users to modify the file.