Shared Workbook - file disappears on LAN

[Scott]

I have worked on a shared workbook twice now in Excel 2000
and both times I have had this problem so I'm looking for
some help.

Issue:
I have a shared spreadsheet (Tools->Share Workbook->I
checked "Allow changes by more than one user...") saved on
our network where multiple people can access the file
simultaneously to make changes. When multiple users are
making modifications, I have had a problem where I lose
spreadsheets. For example, I'll open the spreadsheet and
make changes. After I open the file, but before saving,
somebody else will open the file and make changes. I'll
hit "save" and my updates are saved. The second person who
was simultaneously working on the file will then
hit "save" and get the message "file does not exist." Then
when we look back on the network for the file under "Start-

Search," there is no record of the spreadsheet anywhere.

There's no spreadsheet, there's no temp file, and there's
no record of our work anywhere. Is there something I'm
doing wrong or is there a bug in Excel 2000 for this
feature?