azureazure-devopstfs-workitemazure-devops-extensionsdevops-services

How to open work item query result in microsoft excel from Azure DevOps?


Hi I am trying to open Work item query results in microsoft excel but getting an error "TF208093 you cannot use work item query to generate reports in excel on this server because it is not configured for reporting"

Below are the steps which I performed

1. Installed excel extension from marketplace on Azure DevOps
2. Installed Visual Studio 2017
3. Installed Team Foundation Server Integration 2017

enter image description here

enter image description here

enter image description here


Solution

  • I tested the "open work item query result in microsoft excel" through the excel extension with below process:

    1. Click the “Open in Excel” in Query Results after I installed the Excel extension for my organization:

    enter image description here

    1. Click the “Open TfsProtocolHandler.exe” button in popup dialog

    enter image description here

    1. Now we can see it in Excel opened automatically:

    enter image description here

    The only difference between my process and yours is that i didn't install Team Foundation Server Integration 2017 (I have Visual Studio 2017 on my computer), you can try to uninstall it and do the process again see if we can solve the problem.