XL7: Change Types Displayed in Conflict History/Resolution

ID: Q130105

7.00 WINDOWS kbother kbwwt

The information in this article applies to:

SUMMARY

In Microsoft Excel, when you share a workbook, you may make a change to the workbook that conflicts with a change that another user has made to the workbook. The conflicting change appears in the Conflict Resolution dialog box, and also appears on the Conflict History worksheet box when a conflict occurs.

MORE INFORMATION

A conflict occurs when you enter data in a cell that has already been used. The Conflict Resolution dialog box appears in this case to notify you that you made a change that conflicts with a change made by another user who has already saved the workbook. The types of changes that cause the Conflict Resolution dialog box to appear include changes to a value in a cell and renaming a worksheet.

The type of change that causes the Conflict Resolution dialog box to appear is displayed in the "Your Changes On Sheet" box and the "Conflicting Changes By" box in the Conflict Resolution dialog box, and in the Change column on the Conflict History worksheet. The following list contains the different change type values that can appear in these locations.

   Cell Change
   Sheet Rename
   Range Move
   Sort Cells

KBCategory: kbother kbwwt KBSubcategory: xlwin

Additional reference words: 7.00

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 30, 1997