Steps

1

On the Visual Studio Team menu, click Team Explorer.

2

In Team Explorer, expand your team project folder, then the Work Items folder, and the Project Queries folder.

3

Right-click the Active Bugs query, and choose Open in Microsoft Excel.

4

After you create the bug list, you should save it to the project portal under the Test folder. As bugs are updated, you can refresh the list when it is opened in Microsoft Excel.