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

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

Hello,
I have the following problem with an excel file on a network share.
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
 
It's been my experience on many occasions that whenever I have an Excel file
opened from a network and lose connectivitiy while the file is open, Excel
will not allow me to save back to that location, and actually won't allow
saving to ANY location once the network break occurs. Now, having said that,
it should be noted that my experiences have only been with XL97 and
XL2k......the newer versions may act differently.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top