Share via


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.

Required Permissions

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 Team Foundation Server Permissions.

To resolve data conflicts in Microsoft Project or Microsoft Excel

  1. If there are data conflicts when you try to publish changes to work items, the Work Item Publishing Errors dialog box automatically appears.

  2. For each work item listed with a data conflict, follow these steps.

    1. 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.

    2. 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.

  3. Click Publish.

  4. When all the data conflicts are resolved, click Close.

See Also

Tasks

How to: Publish or Refresh Work Items in Microsoft Excel or Microsoft Project

Other Resources

Publishing and Refreshing Work Items