We recommend using Visual Studio 2017
This documentation is archived and is not being maintained.

How to: Change Multiple Work Items in Microsoft Excel

If you need to 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

  1. In Team Explorer, expand the Work Items node, and locate or create a query that contains the work items that you want to change.

  2. 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.

  3. 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.

  4. Use the editing features in Microsoft Excel to change the values for multiple cells.

    For more information, see Microsoft Excel Help.

  5. After you make all the changes that you want, on the Team tab, in the Work Items group, click Publish.

    The system saves your changes to the work item database.


    In Microsoft Office Excel 2003, use the Team menu.