+ Reply to Thread
Results 1 to 2 of 2

How to prevent conflicts

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    How to prevent conflicts

    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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How ro prevent conflicts

    Hello Alex,

    To create a List on the Worksheet:
    1) Select the cells that will make up the list. They must be contiguous.
    2) On the Main Menu click Data > List > Create List...
    3) Check the box if your list has Headers.

    You will notice a thick blue border around the cells with an asterisk in the last row. Enter new data to be added to the list here and press enter.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1