The below is the document on subject " How to resolve conflicts"taken fro Excel help.
Can anyone show me an example how to make use of it.
Assign each user an area to work in Conflicts occur only when two users make changes that affect the same cell. To make entering lists (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) easier, Excel allows more than one user to add data to the row at the end of a list without triggering conflicts. If users avoid each other's areas, conflicts won't arise even if you don't use worksheet protection to enforce separate work areas.
Regards,
Alex
Bookmarks