Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Microsoft Excel Work Item List Types

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 both what work items 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 are replaced with the work items that match the query.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft