Excel add-in for Azure Dev Ops board integration is experiencing issues

Question

I use Excel to manage work items from an Azure Dev Ops board. Last week, I started to experience a problem with the Excel Add-in. Assuming that the prerequisite is installed... Starting with a new sheet, the repro steps are:

1. Go to the Team tab.
2. Select New List.
3. In the modal window, select the
   1. Azure DevOps Server.
   2. Team Projects Collections.
   3. Team Project.

Then I get the following error:

I've tried Repairing the addin install. I've rebooted my machine. I've opened and closed Excel. I've tried opening the query from ADO.

Answer 1

I updated Excel and the issue went away.