XL7: Conflict Occurs Adding Data to End of List in Shared File

Last reviewed: March 27, 1997
Article ID: Q130558
7.00 WINDOWS kbother

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, when you add a value to the end of a list in a shared workbook file that conflicts with a value added by another user in the same cell, the Conflict Resolution dialog box may appear instead of the value being added to the list as expected.

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

   A1: a
   A2: b
   A3: c

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:

   A1: a
   A2: b
   A3: c
   A4: e
   A5: d

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.

RESOLUTION

To avoid receiving the Conflict Resolution dialog box in a shared file when you add data to the end of a list, make sure that the worksheet that contains the list does not contain any data below the last row of data in the list.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


KBCategory: kbother
KBSubcategory: xlwin

Additional reference words: 7.00
Keywords : xlwin kbother
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.