|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
Working with Work Item Lists in Microsoft Excel
This section covers working with work items using Microsoft Excel. When Team Explorer is installed, a plug-in is inserted into Microsoft Excel which adds a Team menu, and the Work Items toolbar. The Microsoft Excel plug-in provides the ability to create and edit work items using filtering and sorting within the familiar Microsoft Excel environment.
In This Section
Provides an overview of the different kinds of work item lists.
Describes how to edit the project structure and iterations in Microsoft Excel.
Explains the steps used to create a work item within Microsoft Excel.
Describes how to use the column picker to choose which columns of data you want displayed for work items within Microsoft Excel.
Explains the steps used to bind a work item list created in Microsoft Excel to a work item query within a team project.
Describes how to change the refresh options for a work item list.
Describes how to update a work item list that is bound to a work item query.
Describes how to remove work items using Microsoft Excel.
Describes how to make changes to several work items at once in Microsoft Excel.
Describes how to work on your work items in Microsoft Excel when not connected to the Team Foundation Server.