• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 493
  • Last Modified:

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
0
PaulCampbell
Asked:
PaulCampbell
  • 2
1 Solution
 
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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now