Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel documents getting locked by other network users

Posted on 2003-12-02
3
Medium Priority
?
490 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 400 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
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…

618 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