Open In Excel

Ali Bakr 1 Reputation point
2022-08-11T15:13:32.333+00:00

There is no option to open visual studio queries (work items) in Excel. I have already installed the Azure DevOps Office Integration 2019 and Azure DevOps COM add-in is active in Excel.

230543-image.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,931 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anna Xiu-MSFT 25,551 Reputation points Microsoft Vendor
    2022-08-16T05:07:39.133+00:00

    Hi @Ali Bakr ,

    Welcome to Microsoft Q&A!

    You can refer to the similar issue in Developer Community:
    https://developercommunity.visualstudio.com/t/Unable-to-open-TFS-query-results-in-Exce/10058543?space=22&entry=problem&q=open+visual+studio+queries

    If you are using VS2022, it seems be a known issue. Maybe the Azure DevOps Office Integration 2019 has not been released to the VS2022.

    You can vote and add comments in that ticket to track the process.

    Sincerely,
    Anna
    *
    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments