View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pslaught pslaught is offline
external usenet poster
 
Posts: 2
Default Locking Excel for Editing

Thanks All!

"dlw" wrote:

doesn't that happen automatically? On your network, can multiple open and
edit one file? That would be odd.

"pslaught" wrote:

I have a spreadsheet that is available on a shared drive at work.

I've seen it done before where, once the spreadsheet is open by one person,
everyone else can only open it as "read-only." The first person to open the
spreadsheet has the ability to edit it -- thereby, only one person can edit
the spreadsheet at a time.

How do I do this?

Thanks!