Tuesday, April 13, 2010

Changing the workitem list type in Excel

By default if you export a workitem query result to Excel, you always get back a flat list.  Execute following steps to change this flat list to a tree list:

  1. On the Team tab in Office Excel, in the Work Items group, click Add Tree Level.

  2. In the Convert to Tree List dialog box, click Parent-Child or other type of link (only tree link types are listed), and then click Yes.

Team Foundation changes the list structure to a tree list.

No comments: