Working with Work Items in Microsoft Excel and Microsoft Project

Visual Studio Team System provides integration features that allow you to manage work items in Microsoft Excel and Microsoft Project. Use Microsoft Excel to track and share specific information about your team project. For example, you can review high priority bugs, track exit criteria for an iteration, and monitor status for a specific feature area. Use Microsoft Project to break down and assign tasks and track progress.

In Microsoft Excel and Microsoft Project, you view and change work items in a work item list or project file. All changes are stored in the spreadsheet or project file until you publish them to the work item database. Also, you can refresh the work item list or project file so that it matches changes made in the work item database.

In This Section

• How to: Create a Microsoft Excel or Microsoft Project File from a Work Item Query
  Describes how to create a Microsoft Excel or Microsoft Project file containing work items from a work item query.

• How to: Connect to Team Foundation from Microsoft Excel or Microsoft Project
  Describes how to connect to a Team Foundation server from Microsoft Excel or Microsoft Project.

• How to: Add Work Items in Microsoft Excel or Microsoft Project
  Describes how to add new work items using Microsoft Excel or Microsoft Project.

• How to: Import Work Items in Microsoft Excel or Microsoft Project
  Describes how to import work items from the work item database into Microsoft Excel or Microsoft Project.

• Managing Links and Attachments in Microsoft Excel and Microsoft Project
  Provides a conceptual understanding of how links and attachments are managed in Microsoft Excel and Microsoft Project.

• How to: Add a Link in Microsoft Excel or Microsoft Project
  Describes how to add a link or attachment to a work item using Microsoft Excel or Microsoft Project.

See Also

Other Resources

Managing Work Items in Microsoft Excel and Microsoft Project