Share via


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

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: Add New Work Items
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