XL7: Incorrect Value in "Conflicting Changes By" Box

Last reviewed: March 27, 1997
Article ID: Q129443
7.00 WINDOWS kbusage xlwin

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, if the Conflict Resolution dialog box appears when you save changes to a shared file while another user is making changes to the same file, when you click the "Use These Changes" button, the value that is entered in the conflicting cell may not be the value that was displayed in the Conflicting Changes By box as expected.

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.

MORE INFORMATION

Note that when you click the "Use These Changes" button, a dialog box is displayed with the following information:

   Save resulted in some changes from other users


KBCategory: kbusage
KBSubcategory: xlwin

Additional reference words: 7.00
Keywords : xlwin kbusage
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.