Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Bulk modify work items
Collapse the table of content
Expand the table of content

Bulk modify work items

When you want to change one or more fields in several work items, you can bulk modify. For example, you might want to change the priority of several bugs or reassign several tasks to the same team member.

Use the Team Foundation Server (TFS) web portal to quickly modify one or more fields that will all contain the same value. Use Excel to update multiple fields with different values. If you already work in Microsoft Project, then you can use it to perform bulk updates.

From the Query results page, select the work items you want to modify. You can craft your query using the query editor or search box.

Select the work items you want to modify

With work items selected, open the context menu for any selected item, and reassign all of them. By doing this, you can quickly assign them to a member of your team or to another sprint or iteration.

Assign to link from work item context menu

Or, edit all the selected work items at one time. Enter a value for each field that you want to update.

Bulk modify (TWA)

For audit purposes, you can type a description for your bulk update task.

Save all work items that you bulk-modified.

Bulk modify save results (TWA)

Work items shown in bold text indicate that local changes have not yet been saved to the TFS data store.

You can’t change the work item type of an existing work item. However, you can clone an existing work item and specify a new type. Open the work item you want to change, copy it—including all links—and choose the work item type you want.

Copy work item dialogue

The cloned work item is automatically linked to the original work item through a Related link type.

If you have a large number of work items whose type you want to change, you can export them using Excel, copy them to a new Excel list, and reimport them by specifying a different work item type. See Bulk add or modify work items with Excel.

A: From the backlog page in web access, use Create Query to create a query with the backlog items. Then, open the query in Excel to bulk modify the backlog. To change the list order of the backlog, you update either the Backlog Priority or Stack Rank field.

A: You can use the following clients to bulk edit links:

  • Use Excel to edit parent-child or hierarchical links.

  • Use Project to edit parent-child and predecessor-successor link relationships.

  • From the web portal, you can map backlog items to portfolio backlog items which creates parent-child links.

  • Using Team Explorer, you can drag items in a tree query to create or modify parent-child links.

A: If you have implemented a custom control that supports multiple values, you can use Excel to bulk edit the field, but not web access. In web access, you can only select a single value for the field.

A: Review the following topics to learn more:

© 2015 Microsoft