then click on Add… and enter the URL for the Azure DevOps Organization where TheOrganisationName is the name of the Organisation where your Azure DevOps project lives.

If you have already connected to an Azure DevOps Organization before, you will be able to see a list of Azure DevOps servers under Team Project Collections.Ĭlick on Servers. (Hint: always keep your selected cell on the first cell(A1) as any new list you create will use the selected cell as the starting point for your list) Once Excel is opened you should now see the Team tab in your header Ribbon in Excel: Make sure to close any open instances of Excel you may have open and restart Microsoft Excel. Once installed you should have the following screen appear below: Once downloaded, install the solution by running the. How do you set this up? Download Azure DevOps Office Integration 2019 from here:

The Azure Integration Tool for Office 2019 allows you to link your Excel Spreadsheet with your Azure DevOps Queries. One of the tools I use often on projects is the DevOps integration with Excel in order to gain a better visual of To Do, In Progress and Done Tasks associated with each Product Backlog Item.

Excel for mac bugs