Sleeper: How to allow multiple users to update workbook (on network)?

[QAQ]

How can I let multiple users update a single worksheet over a network? e.g. how can I let different users simultaneously (on a network) add new rows to existing rows of data?

I know there's a function called Share Workbook under the Tools menu. I'm not sure how to use it (and I cant test it as I dont have access to a network at the moment).

Can sum1 help?

[Jacob Hilderbrand]

Just enable sharing.

Tools | Share Workbook... | Allow changes from more than one user at a time.

Up to 256 users can have the workbook open at once.

[QAQ]

But what will happen if two users add new row of data in the same row e.g. row 10?