Excel File open in r/w by two users on network connectivity issue

[Guest Jean-Paul]

Hello,

I have the following problem with an excel file on a network share (windows

storage server 2003 R2).

A first user open the file in rw. it lose then network connectivity.

After that, a second user (how asked to be informed when the file is

available) receive the message that the file is available and modify it.

When the first user has network connectivity again, it can save and replace

all values of this file.

Is there a way to maintain the file locked, even on network connectivity

issue?

 

Thanks

 

Jean-Paul

[Guest Anthony]

Re: Excel File open in r/w by two users on network connectivity issue

 

Hi Jean-Paul,

I would ask this question in the Office/ Excel newsgroups.

From a file server point of view, the answer is no. The server is just a

storage box. To do what you describe you would need a check-in, check-out

service (maybe SharePoint?)

Anthony, http://www.airdesk.com

 

"Jean-Paul" <JeanPaul@discussions.microsoft.com> wrote in message

news:76B17755-341F-4FDB-B1B1-502C62BACE97@microsoft.com...

> Hello,

> I have the following problem with an excel file on a network share

> (windows

> storage server 2003 R2).

> A first user open the file in rw. it lose then network connectivity.

> After that, a second user (how asked to be informed when the file is

> available) receive the message that the file is available and modify it.

> When the first user has network connectivity again, it can save and

> replace

> all values of this file.

> Is there a way to maintain the file locked, even on network connectivity

> issue?

>

> Thanks

>

> Jean-Paul