Export (0) Print
Expand All

How to: Change a Query List into an Input List

When you work with work items in Microsoft Excel, the type of work item list you select affects how the work item list is refreshed from the work item database.

  • Query list   When you create a query list, refreshing the work item list updates the work items that are in the list and the information for the work items. In the work item list header, under Query, query lists contain the name of the query to which they are connected.

  • Input list   When you create an input list, refreshing the work item list updates only the information for the work items already in the list. In the work item list header, under Query, input lists contain [none].

Caution noteCaution

When you change from an input list to a query list, the work items that you have added to the list will be replaced with the work items that match the query.

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 change a query list into an input list

  1. From Team Explorer, open the work item list in Microsoft Excel. For more information, see How to: Connect to Team Foundation from Microsoft Excel or Microsoft Project.

    Caution noteCaution

    When you change from a query list to an input list, refreshing the list updates only the work items currently included in the list.

  2. On the Team menu, select Configure List.

    NoteNote

    In Microsoft Office Excel 2007, the Team menu is located on the Add-Ins tab on the ribbon.

  3. Click Refresh current work items only.

  4. Click Apply. The query header displays [none] to indicate that the work item list is now an input list.

See Also

Community Additions

ADD
Show:
© 2014 Microsoft