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 tab to the Ribbon. The Microsoft Excel plug-in provides the ability to create and edit work items using filtering and sorting within the familiar Microsoft Excel environment.
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.
How to: Connect a Work Item List to a Work Item Query
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.
How to: Update a Work Item List from a Query
Describes how to update a work item list that is bound to a work item query.
How to: Remove Work Items in Microsoft Excel
Describes how to remove work items using Microsoft Excel.
How to: Change Multiple Work Items in 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.