Open workbook for multiple people

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi again -

I have a workbook and want to have multiple people work on it
simultaneously. Now, it lets the 2nd person open it - read only. How can I
make it open for 2-3 people to hammer on at the same time?
Thanks!

Alan
 
I have a workbook and want to have multiple people work on it
simultaneously. Now, it lets the 2nd person open it - read only. How can I
make it open for 2-3 people to hammer on at the same time?
Click to expand...

You may be able to use a shared workbook. That's the only way Excel allows
multiple people simultaneous write access to the same file. The reason for this
sort of restriction is obvious: if users A and B enter different values into
cell foo!X99 and then save, which value of foo!X99 should be saved? If user A's
version is saved, does that mean user B's foo!X99 much be changed automatically
to reflect user A's saved entry?
 
Back
Top