Solved

Excel documents getting locked by other network users

Posted on 2003-12-02
3
438 Views
Last Modified: 2010-03-19
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
0
Comment
Question by:PaulCampbell
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
ShineOn earned 100 total points
ID: 9857733
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
 
LVL 2

Author Comment

by:PaulCampbell
ID: 9858760
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
 
LVL 2

Author Comment

by:PaulCampbell
ID: 9858837
Oh sorted - got it cheers man
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now