How to: Resolve Data Validation Errors in Microsoft Excel or Microsoft Project

  • Article

Microsoft Visual Studio Team System Office integration features can help you avoid entering values that are not supported by the work item fields. These integration features prevent most data validation errors. However, if your project file or spreadsheet contains unsupported values, the system adds a warning to the cell that contains the unsupported data.

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 validation errors

  1. In Microsoft Excel or Microsoft Project, publish your changes to the Team Foundation Server.

    For more information, see How to: Publish or Refresh Work Items in Microsoft Excel or Microsoft Project.

  2. If there are data validation errors or conflicts, the Work Item Publishing Errors dialog box automatically appears.

  3. For each work item listed with a data validation error, follow these steps.

    1. Select the work item.

      The Details pane displays the data validation error for the selected work item.

    2. Select Edit Work Item to open the work item form and correct the value.

      Values that must be corrected are highlighted.

      Note

      If the data validation error is unavailable on the work item form (for example, if you have not specified a work item type), the Edit Work Item button is unavailable, and you must correct the error in Microsoft Excel. For more information, see the following procedure, "To resolve data validation errors by using error checking."

    3. Select Close to save your changes and close the work item form.

  4. As you correct the data validation errors, the Status column will change to Ready to Publish. Click Publish to publish the work items that are ready to publish.

    Note

    The Team Foundation add-in will not publish any work items that still have data validation errors.

  5. Click Close to close the Work Item Publishing Errors dialog box.

To resolve data validation errors by using error checking in Microsoft Office 2003

  1. In Microsoft Excel, on the Tools menu, click Error Checking.

  2. Look at the Help displayed in the Error Checking box. If you need more information about the error, click Help on this error.

  3. Select the cell with the error, and correct the value.

  4. In the Error Checking dialog box, click Resume to find the next data validation error.

  5. When you have corrected all errors, you receive a message that states that error checking has completed. Click OK to close this message and the Error Checking dialog box.

To resolve data validation errors by using error checking in Microsoft Office 2007

  1. In Microsoft Excel, on the Formulas tab on the ribbon, click Error Checking.

  2. Look at the Help displayed in the Error Checking box. If you need more information about the error, click Help on this error.

  3. Select the cell with the error, and correct the value.

  4. In the Error Checking dialog box, click Resume to find the next data validation error.

  5. When you have corrected all errors, you receive a message that states that error checking has completed. Click OK to close this message and the Error Checking dialog box.

See Also

Tasks

How to: Resolve Data Conflicts in Microsoft Excel or Microsoft Project