View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Read only message caused by camping out in file

When I try to open a workbook in two instances of excel, I get an error
message that reads:

Book1.xls is locked for editing
by 'Barb Reinhardt' ...

Do you not get that? I'm in Excel 2003.

Barb Reinhardt

"Rhett C" wrote:

In my office we have different departments that use one main worksheet that
everyone fills in their section's data. I continuously get the READ ONLY
NOTIFY message because the file is being used by someone else or they are in
the worksheet and have left their desk doing something else. I have to walk
around the office and find out who is in the file and ask them to get out.
Is there a way to display the username that is currently using the file when
the read only message comes up? thanks!