Incorrect Value in "Conflicting Changes By" Box (129443)

CAUSE

This behavior occurs because the "Conflicting Changes By" box in the Conflict Resolution dialog box may not display the "current" value that is contained in the conflicting cell on the worksheet that the other user is modifying. The value displayed in the "Conflicting Changes By" box is the value that is contained in the conflicting cell when the conflict first occurs. This behavior is by design of Microsoft Excel so that you are not prompted multiple times for changes in the same conflicting cell.

Although only the first conflicting change is displayed in the "Conflicting Changes By" box, when you choose to use the changes to the cell, the value that is entered in the conflicting cell is the current value that is contained in that cell on the worksheet that the other user is modifying.

For example, consider User1 and User2 who are both editing Sheet1 in the shared file BOOK1. If User1 enters the value "1/2/1995" in cell A1, and saves the file, and then changes the value in cell A1 to "January" and saves the file, when User2 enters a value in cell A1 and saves the file, the Conflict Resolution dialog box appears as expected. However, the "Conflicting Changes By User1" box contains the original value "1/2/1995" instead of the current value "January." If User1 clicks the "Use These Changes" button, the current value "January" is entered in cell A1 as expected.