Open workbook for multiple people

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

"Alan" wrote...
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?

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.