Avatar of evdmerwe
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?
Windows Server 2003Office ProductivityNetwork Management

Avatar of undefined
Last Comment
Leon Fester

8/22/2022 - Mon
Abbas Haidar

use microsoft Groove
tonyperth

Try stopping your Anti-Virus from scanning the network drive from the clients.  Obviously let the server scan the folder though.
evdmerwe

ASKER
I can't see that the AV is the problem, in that it works most of the time.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
tonyperth

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
Leon Fester

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question