Share via


How to: Remove Work Items in Microsoft Excel

Work item lists are easily managed by common Excel functionality. One such functionality is the ability to delete and sort data as may be required for reporting and investigation. The following procedure describes the steps used to remove an individual work item from a work item list within Microsoft Excel.

Required Permissions

To perform these procedures, you must be a member of the Readers group or have the View work items in this node permission set to Allow. For more information, see Team Foundation Server Permissions.

To remove a work item in the work item list in Microsoft Office Excel 2003

  1. Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.

  2. In Microsoft Excel, click the row number associated with the work item that you want to remove.

  3. Right-click the row number, and click Delete. The row is removed from the work item list.

    Warning

    Work items are permanent and are never deleted from the database. The work item is only removed from the work item list within Microsoft Excel and is not removed from the task item lists stored in the work item database.

    Note

    You can also select multiple rows and delete them simultaneously.

To remove a work item in the work item list in Microsoft Office Excel 2007

  1. Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.

  2. In Microsoft Excel, click the row number associated with the work item that you want to remove.

  3. Right-click the row number, and click Delete and then click Table Rows. The row is removed from the work item list.

    Warning

    Work items are permanent and are never deleted from the database. The work item is only removed from the work item list within Microsoft Excel and is not removed from the task item lists stored in the work item database.

    Note

    You can also select multiple rows and delete them simultaneously.

See Also

Other Resources

Working with Work Item Lists in Microsoft Excel