How to: Change Multiple Work Items in Microsoft Excel
If you must change multiple work items at the same time, you can open them in Microsoft Excel and quickly make global changes using Microsoft Excel editing features.
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 change multiple work items in Microsoft Excel
In Team Explorer, expand the Work Items node, and locate or create a query that contains the work items that you want to change.
In Team Explorer, right-click the query, and then select Open in Microsoft Excel. You can also click the Microsoft Excel icon in the toolbar.
If it is required, add the fields that you want to edit to the work item list. For more information, see How to: Add or Remove Columns in the Work Item List.
Use the editing features in Microsoft Excel to change the values for multiple cells. For more information, see Microsoft Excel Help.
When you have made all the changes that you want, from the Team menu, select Publish Changes to save your changes to the work item database.
Note
In Microsoft Office Excel 2007, the Team menu is located on the Add-Ins tab on the ribbon.