As a follow up to Gregg's post on querying on links and creating tree queries, I'd like to introduce you to managing work item hierarchies in Microsoft Excel.
Creating work item hierarchy
There are a few ways you can get started with creating hierarchies in Excel:
You will notice multiple Title columns in the list, one for each level in the hierarchy of work items.
Extending the hierarchy
Updating hierarchy links
To add, remove or update hierarchy links, you do not have to use the Links and Attachments dialog for each work item. This can be easily accomplished by moving the title values from one Title column to another. More over, it allows you to create and edit links in bulk.
Let us know what you think about this functionality and how you plan to use it.