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.
In This Section
Microsoft Excel Work Item List Types
Provides an overview of the different kinds of work item lists.
How to: Change Project Structure and Iterations in Microsoft Excel
Describes how to edit the project structure and iterations in Microsoft Excel.
How to: Create a Work Item List
Explains the steps used to create a work item within Microsoft Excel.
How to: Add or Remove Columns in the Work Item List
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.
How to: Change a Query List into an Input List
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.
How to: Work Offline in Microsoft Excel
Describes how to work on your work items in Microsoft Excel when not connected to the Team Foundation Server.
See Also
Tasks
How to: Create a Microsoft Excel or Microsoft Project File from a Work Item Query
Other Resources
Managing Work Items in Microsoft Excel and Microsoft Project