Allowing users to edit the same Excel file at the same time

Link:
http://www.experts-exchange.com/...

Scroll all the way to the bottom and look for the answer in green (Accepted Solution)


To allow users to only edit specific ranges when working in a shared workbook:

From the Tools menu, select Protection, and then Allow Users to Edit Ranges.
This advanced option allows multiple users (for example, when working on a network) to update data in a well defined and private area. Each workbook user is allotted a range in the sheet with a unique password.

Link:
http://www.exceltip.com/st/...