evdmerwe
asked on
Excel
Hi,
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.
Any suggestions?
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.
Any suggestions?
Last Comment
Abbas Haidar
use microsoft Groove
Try stopping your Anti-Virus from scanning the network drive from the clients. Obviously let the server scan the folder though.
ASKER
I can't see that the AV is the problem, in that it works most of the time.
We have had similar problems at a couple of sites with Excel files on a network share. It was also intermittant and as soon as we stopped scanning network drives we stopped having the problem. Another symptom was that when a user went to save the file they would often get a reply that they could not save it as the file was in use.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Windows Server 2003
Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).
129K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
