Show All

Hide All

When two users try to save changes that affect the same cell, Microsoft Excel displays the Resolve Conflicts dialog box for one of the users.

1. In the Resolve Conflicts dialog box, read the information about each change and the conflicting changes made by others.
2. To keep your change or the other person's change and go on to the next conflicting change, click Accept Mine or Accept Other.

   To keep all of your remaining changes or all of the other users' changes, click Accept All Mine or Accept All Others.

3. To have your changes to override all other changes, and never see the Resolve Conflicts dialog box again, turn this feature off.

   How?

   1. On the Tools menu, click Share Workbook, and then click the Advanced tab.

   2. Click The changes being saved win.

   3. Click OK.

4. To see how you or others resolved past conflicts, view this information on the History worksheet (History worksheet: A separate worksheet that lists changes being tracked in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.).

   How?

   1. On the Tools menu, point to Track Changes, and then click Highlight Changes.

   2. In the When box, click All.

   3. Clear the Who and Where check boxes.

   4. Select the List changes on a new sheet check box, and then click OK.

   5. On the History worksheet, scroll to the right to view the Action Type and Losing Action columns.

      Conflicting changes that were kept have "Won" for Action Type. The row numbers in the Losing Action column identify the rows with information about the conflicting changes that weren't kept, including any deleted data.

Tip