How to: Resolve Data Validation Errors in Microsoft Excel or Microsoft Project
Most data validation errors are prevented by Visual Studio Team System Office integration features that help you avoid entering values that are not supported by the work item fields. However, if your project file or spreadsheet contains unsupported values, a warning is added to the cell that contains the unsupported data.
Note
With the default options in Microsoft Excel, a green triangle indicator on certain cells may indicate a Number Stored as Text data validation message. If you want to disable this error, you can turn off this data validation option in Microsoft Excel. On the Tools menu, select Options, and then on the Error Checking tab, under Rules, clear the Number stored as text option.
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
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.
If there are data validation errors or conflicts, the Work Item Publishing Errors dialog box automatically appears.
For each work item listed with a data validation error, follow these steps.
Select the work item.
The Details pane displays the data validation error for the selected work item.
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."
Select Close to save your changes and close the work item form.
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
Any work items that still have data validation errors will not be published.
Click Close to close the Work Item Publishing Errors dialog box.
To resolve data validation errors by using error checking in Microsoft Office 2003
In Microsoft Excel, on the Tools menu, click Error Checking.
Look at the Help displayed in the Error Checking box. If you need more information about the error, click Help on this error.
Select the cell with the error, and correct the value.
In the Error Checking dialog box, click Resume to find the next data validation error.
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
In Microsoft Excel, on the Formulas tab on the ribbon, click Error Checking.
Look at the Help displayed in the Error Checking box. If you need more information about the error, click Help on this error.
Select the cell with the error, and correct the value.
In the Error Checking dialog box, click Resume to find the next data validation error.
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