excel file disappearing

[James Birch]

I am the administrator of a medium sized business. There
is a particular excel spreadsheet that is being used by
about 13 users. I have had to restore this file 3 times in
the last two weeks as for some reason it disappears. The
users have said the file is in high demand with users
requesting that they be notified when the file is
available for editing and not just read only. Now I know
this could be a user error situation with someone
accidentally deleting the file, but it seems to coincide
with a number of users waiting to be notified of the files
availability concurrently and then one of them will notice
that file is no longer there.
Is there any issue with excel that might cause this?
Any advice or help would be welcomed.
thanks,
James Birch

 

[Ashley]

-----Original Message-----
I am the administrator of a medium sized business. There
is a particular excel spreadsheet that is being used by
about 13 users. I have had to restore this file 3 times in
the last two weeks as for some reason it disappears. The
users have said the file is in high demand with users
requesting that they be notified when the file is
available for editing and not just read only. Now I know
this could be a user error situation with someone
accidentally deleting the file, but it seems to coincide
with a number of users waiting to be notified of the files
availability concurrently and then one of them will notice
that file is no longer there.
Is there any issue with excel that might cause this?
Any advice or help would be welcomed.
thanks,
James Birch
.
Why don't you write some code in VB or something to check

the status of the file? If the file is open, display a
message box informing the user that the file is already in
use. If the file is not open, have your VB application
open the file. You can also write code in the VB
application or the Excel file so the user has to have a
password (that you the administrator creates) to delete
the file.