Top of PageYou might encounter one or more errors while working with the Datasheet view. Some errors can be resolved by simply repeating the action or by refreshing the view, while others require a little more effort. Depending on the error, the view will provide you adequate information to help you resolve the error.
Errors that you can resolve by retrying your changes:
Errors that you can resolve by discarding your changes:
) icon in the corresponding row, and also in the status bar. You will also see the text Click to resolve errors in the status bar. If there are conflicts and errors, you will see the text Click to resolve data conflicts and errors. The following illustration shows the Resolve Errors dialog box.
The details grid displays all the columns in your current view. For the affected row, it shows the change you made. Note that you cannot edit the values displayed in the details grid. At the top of the dialog box, you can see the description of the error.
If there are multiple errors, you can view details of each error by clicking the Previous and Next buttons on the top right of the dialog box.
Based on the error information in the details grid, you could either ignore the changes you made, or retry your changes. When there are multiple errors, you can take individual actions for each error, or take a single action for all errors. To ignore or retry all of your errors, click Discard All My Changes or Retry All My Changes.
Note that any action you take to resolve an error might result in a new error. In that case, the dialog box will be updated to include details of the new error.
You can close the dialog box without taking any action, but you will not be able to leave or refresh the list, or make changes to a calculated column, until you resolve the error.