Data Consistency

The add-in helps prevent multiple users from overwriting each other’s changes.

Consider this scenario:

1. Person A downloads information from a business object into a table in their integrated workbook.

2. Person B downloads the same information into a table in their integrated workbook, edits it, and uploads changes.

3. Person A then edits the same information (downloaded in Step 1) and uploads the changes.

4. The add-in provides the service with the necessary information to prevent Person A's changes from overwriting those changes made by Person B. Instead, when the server detects such a change, its response allows the add-in to display an error message similar to the following for any such rows in the table:

This row has been modified by another user. Please download before editing.

If you see this message for only some rows in a table, you can select those rows and use Download Selected Rows to refresh just the conflicted rows. This replaces the selected rows with the latest data from the web application, but does not discard changes in other rows. See Download Selected Rows in a Table.

After the selected rows are refreshed, redo your changes on those rows as needed.

Note: Some web applications do not support this conflict detection functionality. If the web application does not, then Person A’s changes will replace Person B’s changes with no warning. Contact the application owner for more information.