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
Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.
In Microsoft Excel, click the row number associated with the work item that you want to remove.
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
Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.
In Microsoft Excel, click the row number associated with the work item that you want to remove.
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.