How to: Resolve Data Conflicts in Microsoft Excel or Microsoft Project
When you publish work items to the work item database, there might be differences in the data between the Microsoft Project or Microsoft Excel file and the work item database. You must resolve these differences before the work items can be published.
To perform these procedures, you must be a member of the Contributors group or have the View work items in this node and Edit work items in this node permissions set to Allow. For more information, see.
To resolve data conflicts in Microsoft Project or Microsoft Excel
If there are data conflicts when you try to publish changes to work items, the Work Item Publishing Errors dialog box automatically appears.
For each work item listed with a data conflict, follow these steps.
Select the work item.
The Details pane displays the conflicting fields for the selected work item. The local value and server value are shown for each conflicting field.
For each conflicting field, determine the correct value (either local or server) and select that value.
This determines which value to keep. If you choose local, the local version overwrites the value in the server. If you choose server, the server version overwrites the local value in the document.
When all the data conflicts are resolved, click Close.