Resolve Invalid Links in a Microsoft Excel List Tree

Article
04/17/2013

If you try to publish a tree list that contains an invalid link, the Work Item Publishing Errors dialog box appears and displays an error message that states why the tree is invalid. When you work with work items in a tree in Microsoft Excel, the tree must be in a valid state before it can be published. In Excel, an invalid link occurs in a tree list of work items if the title of a work item title is missing or occurs in the wrong title column.

To address or resolve the most common errors around links that are not valid, complete one of the following procedures:

Resolving Error TF208000: Duplicate Titles
Resolving Error TF208001: Orphaned Work Items
Resolving Error TF208017: Missing Title 1 in the First Row
Resolving Error TF208022: Sorted Tree List
Addressing Error TF208102: Excel Sort on a Tree List
Addressing Error TF208104: Hierarchical Link Relationship Is Locked

Required Permissions

To perform these procedures, you must be a member of the Contributors group or have your View work items in this node and your Edit work items in this node permissions set to Allow. For more information, see Team Foundation Server Permissions.

Resolving Error TF208000: Duplicate Titles

If you add a value to multiple Title columns of a work item, when you try to publish the tree, the error message TF208000 appears in the Work Item Publishing Errors dialog box. The error message specifies the row number of the invalid link.

To resolve a duplicate title

Note the row number that appears in the dialog box.
Close the Work Item Publishing Errors dialog box.
In the work item list, find the row that the error message specified.
Delete the duplicate title or titles so that only one title column has a value.
On the Team tab, in the Work Items group, choose Publish.

Resolving Error TF208001: Child Work Item Disconnected from Parent

If you remove the title of a child work item, when you try to publish the work item list the error message TF208001 appears in the Work Item Publishing Errors dialog box. The error message specifies the row number of the invalid link. This error message also appears if you create an invalid link structure by putting the title of a child work item into the wrong column.

Note

If you put a title in the wrong column, the resulting tree structure might be valid but not match your intent. The system cannot detect this problem, therefore, an error message does not appear.

To resolve an orphaned work item

Note the row number that appears in the dialog box.
Close the Work Item Publishing Errors dialog box.
Find the row that the error message specified.

Note

The misplaced title might be in this row, or it might be in the next row.
Move the title to the correct column to fix the invalid link.
On the Team tab, in the Work Items group, choose Publish.

Resolving Error TF208017: Missing Title 1 in the First Row

If the first work item in the list has no value in the Title 1 column, the error message TF208017 appears in the Work Item Publishing Errors dialog box when you try to publish the work item list.

To resolve a missing title in the first row

Close the Work Item Publishing Errors dialog box.
Determine why the first work item lacks a Title 1 value.

The analysis of the cause of the error determines what you must do to repair the work item list.
1. If the first work item should be at the top of the list, move its title value into the Title 1 column.
2. If the first work item should be lower in the list, move the correct work item to the top of the list.
  
  For more information about how to move work items, see Bulk add or modify work items with Excel.
On the Team tab, in the Work Items group, choose Publish.

Resolving Error TF208022: Sorted Tree List

If you have not installed Service Pack 1 for Visual Studio 2010 or later version, the following error message appears when you choose Publish after you have sorted the work items in a tree list:

TF208022: Cannot publish a sorted tree list. Before you can publish, you must clear any sort criteria applied to this work item list. Be aware that the order of work items has changed. Removing sort criteria will not return the list to its original order. Verify that all of the parent-child relationships in the tree are correct before you publish.

You cannot publish your changes until you re-establish the tree hierarchy. You can resolve this error condition either by discarding your changes and refreshing the list or by manually restoring the hierarchy and then publishing the list.

To resolve sorted tree list issues

Choose Refresh to discard your changes and restore the tree hierarchy.

Note

If you refresh the tree list, you remove all your changes other than the sort. To refresh the tree list, on the Team tab, in the Work Items group, choose Refresh.
Manually restore the tree hierarchy by moving the row entries of child items under their parent items. Then, on the Team tab, in the Work Items group, choose Publish.

Addressing Error TF208102: Excel Sort on a Tree List

The following error message appears if you sort the work items in a tree list in Excel:

TF208102: You have performed an Excel sort on a tree list. This action removed the modified or newly introduced hierarchical link relationships of the tree.

You can still publish the changes you have made to individual work items. After you publish, the list will restore to previous hierarchy.

In general, you should not sort a tree list whose hierarchy has been modified.

This message indicates that you can publish the changes that you made to the fields, but all changes that you made to the link hierarchy have been discarded. The tree hierarchy automatically reverts to its original structure.

To publish changes and retrieve the tree hierarchy

On the Team tab, in the Work Items group, choose Publish.
Choose Refresh.

Addressing Error TF208104: Hierarchical Link Relationship Is Locked

If you publish a worksheet that contains work items that are synchronized with Project Server and whose hierarchical link relationships are locked ( Link is locked ), the following error message may appear:

TF208104: You have modified one or more hierarchical link relationships that may have been locked by other processes, such as Project Server.

Changes that you made to individual work items were published. Changes that you made to locked links were auto-corrected.

This error appears when you change the link hierarchy that contains locked links. This message indicates that the changes that you made to the fields are published, but all changes that you made to the link hierarchy, whether locked or not locked, are not published and were reverted to their original assignments.

To modify hierarchical links that are locked, make your changes in the enterprise project plan that is mapped to the team project. For more information, see Manage Project Details in an Enterprise Project Plan Mapped to a Team Project.

To publish changes to links that are not locked

For work items that are not synchronized, you can modify the hierarchical link relationship from Team Explorer or Team Web Access. For more information, see Work with linked hierarchies (Tree of Work Items).
To modify hierarchical link relationships that are not locked in Excel, revise the query that you use to export the work items to exclude all work items whose links are locked. For example, you can add a clause to the filter criteria to omit items whose Project Server Is Linked field is set to Yes.