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.
25,366 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AnnaXiu-MSFT 12,931 Reputation points
    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.