Solved

Excel documents getting locked by other network users

Posted on 2003-12-02
3
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Diagnosing Ethernet network problems on Windows 2012 R2? 3 93
Cisco Edge Routers for BGP 6 95
Cisco router 4400 and switch connection. 27 53
Sonos and 5ghz 14 50
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

733 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