Excel

evdmerwe
evdmerwe used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Abbas HaidarSenior Infrastructure Manager

Commented:
use microsoft Groove
Try stopping your Anti-Virus from scanning the network drive from the clients.  Obviously let the server scan the folder though.

Author

Commented:
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.
Senior Solutions Architect
Commented:
I think you should read this kb:
http://support.microsoft.com/kb/269860

It includes a reference to another KB
http://support.microsoft.com/kb/129276 -  You receive a "This file is locked" error message when you try to save or close a shared file

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial