shared excel file “locked for editing”Locked
I have a shared excel doc that two users on my Windows 2000 LAN need to access at the same time. I have set up a sharepoint and have supplied Full Access share and NTFS permissions to the file. Both users have this file open on their desktops all day and both make changes to the file. Everything was working fine until one day, out of the blue, they both received error messages on morning indicating that the file was in use and “locked for editing” and that they could only open a read-only copy of the file. Neither of them had the file open. When I checked the server – there was no indication that the file was in use anywhere else on the network. A reboot of the server fixes the problem, but this is the third time it has happened in the past 2 months and I don’t like rebooting our primary file server in the middle of the day to fix the problem – any suggestions?