Excel documents getting locked by other network users

Hi,

I have a windows 2000 SBS Server, with about 20 computers running a variety of windows xp pro, 2000 and nt4.  I am having problems with one of my excel documents located in a shared folder on the server.  When users try to open the document, more often than not, they recieve a message saying that the document is currently locked by another user.

When checking with another user, it becomes clear that he/she does not have the document open at all.  The only way to counter the problem is to make a copy, change its file name, and ignore the old, locked file.

The users are running office 97

I would be most greatful for any advice on this issue.  Thanks in advance

Paul
LVL 2
PaulCampbellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShineOnCommented:
This is caused by Opportunistic Locking.  You may want to consider turning off that feature.

It is meant to add a measure of performance to the Windows environment, but often causes issues like this, especially when sharing files that are not made to work with the Opportunistic Locking process.

What is happening here is that a user is opening the file, the user's PC places an exclusive lock on the file and caches a copy of the file on the user's PC, the user makes the changes and saves the changes, then eventually the cached, updated version of the file overwrites the shared, locked version.

Some older applications, like Office 97, don't handle this type of file caching well and sometimes do not flush the cache properly or release the lock until the program is closed, rather than just when the file closes.

If you are comfortable with making changes to the Windows registry, we can help you disable Oplocks; otherwise you might want to consider callin in a consultant to make the changes for you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PaulCampbellAuthor Commented:
Thanks ShineOn


No, I'm happy with messin with regedit
which registery key do i need to change, and where located (On clients or server?)
0
PaulCampbellAuthor Commented:
Oh sorted - got it cheers man
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.