View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default prevent deletion of a workbook in a shared network drive

In article , GS wrote:
My company saves 2010 excel workbooks in a shared network drive. The
problem is that everyone has access to them so sometimes they are
mistakenly deleted. Is there a way to protect the 2010 excel
workbooks so that they can not be deleted from the shared network
drive?


Permissions???


I see the classic "security vs access" dichotomy here. :)
I suspect that the OP's staff are needing write access to these files, which
really means they aren't secure anyway - someone could delete all the data
and save the file (for example). I suggest people keep their files secure on
their computer, and copy them to the shared drive regularly. Then you have a
'which file is the current one and how current is it' problem of course. :)
Or you could rely on regular and frequent backups of the whole disk ?

My understanding of shared drives is that permissions aren't easily settable
by file, and given write access, it's all kind of moot anyway. :)

Security or access remains the question. I don't think there's been a good
answer yet. :) :)