Bulk modify work items
You can use bulk modify to create and change multiple work items with Team Web Access, Microsoft Excel, or Microsoft Project. Use bulk modify to do one of the following tasks:
Reassign or move several work items to a different iteration.
Set the priorities or update the status for several work items.
Reassign select work items to different team members.
Review the current sprint tasks and update completed and remaining work.
Use Team Web Access when you have work items with fields where you want to assign the same value. Use Excel when you want to review a number of work items and update multiple fields with different values. If you already work in Project, then you might prefer instead to use it to perform bulk updates to work items that you want to publish.
The first step is to select the work items that you want to modify. Open the work items page and run a query that contains the items to update. Then, select the work items from the query results list as shown in the following illustration.
To specify a contiguous range of work items, press and hold the SHIFT key while you choose the first and last work item in the range. To specify a non-contiguous range, press and hold the CTRL key when you choose each work item.
To update one or more work items with the same values for a few fields, you can use Team Web Access.
Select the work items from the Query Results view.
Open the shortcut menu for one of the selected items and choose Edit selected work items.
Select the fields you want to update, and enter a value for each field that you select. Remember that all the selected work items will be updated with the new values.
Enter a description for your bulk modification task under the Notes for History, and then choose OK.
To commit the updates to the data store, choose Save Results. Note that Work Items shown in bold text indicate that the modifications are not yet published to the data store.