Open workbook for multiple people

[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

 

[Harlan Grove]

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?

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?