Discussion Locked

NT file lock notification problems

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have two domains in two different locations. There is a particular folder which is used by our sales support group. This folder contains an excel file which is in constant use between the two domains. I have a complete trust relationship between the two domains and 2 WINS servers, one in each location.The one in location A acting as primary and the one in location B acting as as secondary and vice versa. A user in location A will open the excel file and make changes to it. A user in location B will open the same file and she will get a notification that she has read access because the file is already in use which is what shuold be the case. Before user A saves her changes, B will be notified that she now has write access. She wil start making changes to it. When A finishes and tries to save her changes she will receive a message "file save not complete. Retry or cancell". Eventually nobody is able to save. The problem normally happens between location A and B and neither in A nor B.Can somebody help me??????

4 replies

by rosah

I'm not sure what version of Excel this involves, but Excel 2000 has a feature for "workbook sharing" that allows Excel to internally manage multiple users making multiple saves. You might want to check if they are using it or not and try changing the setting.

by shanghai sam

I know this feature but I want to solve the problem at the server side since the users cannot take care of file merging which results as a result of enabling workbook sharing.It's Office 2000. Thanks anyway.

by steby

I found the answer. I had to diable opportunistic locking in the registry on the NT server and workstations.

This discussion is closed to new replies.