Conflict Occurs Adding Data to End of List in Shared File (130558)

CAUSE

This behavior occurs if the worksheet in the shared workbook contains data in a row below the last row of data in the list. For example, when you enter a value in a cell at the end of a list in column A, for example cell A4, in a shared workbook, if another user has entered a different value in cell A4 on the same worksheet and saved the file, the Conflict Resolution dialog box appears if there is a value on the worksheet in cell E25. Normally, when you enter a value in a cell at the end of a list in a shared workbook, if the value conflicts with a value entered in the same cell by another user, an additional row is inserted in the list for the value that you entered, and the value that the other user entered is added to the end of the list. For example, if one user enters the value d in cell A4, at the end of the following list and then saves the file, when you enter the value e in cell A4 on the same worksheet, the list appears as follows when you save the file: The Conflict Resolution dialog box does not appear in this case. However, if data appears on the worksheet below the last row of data in the list, a new row is not inserted in the list because of the possibility of pushing the data that appears below the list off of the last row on the worksheet.