Allow only one user to access workbook at a time

  • Thread starter Thread starter Emir_of_shmow
  • Start date Start date
E

Emir_of_shmow

I need to set excel to allow only one user at a time to access a
workbook.
The workbook is NOT a shared workbook, but it resides on a network
share. Multiple users need to access it, but only One at a time. I
want all other users to get a message that the file is in use and they
can not open it.
Is this possible?
 
I believe that is the standard behavior of a network file that is not
shared; users who access the file when it is in use get a message the file
is in use and whether they want to open as Read Only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
corrupted shared excel workbook 1
shared workbook - shared workbook options grayed out 0
SHARING Workbooks 1
Merge Multiple workbook sheets into one workbook 0
sharing workbooks 4
Excel Protection 2
Shared Workbook READ ONLY access 3

Back
Top