Resolve conflicting changes and errors in Datasheet view

Microsoft Datasheet View

Resolve conflicting changes and errors in Datasheet view

  1. Click Resolve on the status bar to display the Resolve Conflicts and Errors dialog box.
  2. Do one of the following:

    • To resolve the currently displayed conflict or error by ignoring the changes you made to the row, click Discard My Changes. Your changes will be lost.
    • To resolve all pending conflicts and errors by ignoring all of your changes to the list, click Discard All My Changes.
    • To resolve the currently displayed conflict or error by reapplying your changes, click Retry My Changes. In case of a conflict, if you and the other user change the same column, your changes will overwrite the other user's changes. If you edit different columns, your changes will be merged with the other user's changes.
    • To resolve all pending conflicts and errors by reapplying your changes, click Retry All My Changes.
    • To view the details of the next conflict or error, click Next on the top right corner of the dialog box.
    • To view the details of the previous conflict or error, click Previous on the top right corner of the dialog box.
    • To resolve conflicts and errors at a later time, click Close on the dialog box title bar.

Notes

  • The details grid shows all the columns in your current view. If the columns are not visible, use the horizontal scroll bar to scroll, or drag the right edge of the dialog box to increase the width of the details grid.

    To zoom the contents of a column, click the column in the details grid. Your changes and the other user's changes will be displayed in the Field Details dialog box. The dialog box is also useful for viewing rich text formatting changes.

  • The details grid displays Deleted row, instead of a row of data, if either you or the other user deletes a row. If the other user deletes the row, the dialog box does not display the name of the user or the date and time of the deletion. Also, you will not be able to retry your changes.