Office Add-in for Visual Studio crashing when using Open in Office for a DevOps Query

Hi…

Long Time no see… good to be back

I am making heavy use of DevOps queries in my daily tasks as release manager/scrum master at my customer. Especially when it comes to generating release notes.

Currently I have a query returning all DevOps Items, Ready for Release and tagged with Hotfix. I open them in Excel, format them a bit and paste them into ours Microsoft Teams Wiki. Excel really makes this table-tweaking much easier.

Today Excel kept crashing when I used Open in Excel and I could not figure out why. I used it successfully last week. After some googling I bumped into a forum post that told me to clear cache folders for Team Foundation Service. It helped !! Yay!!!

The article is linked below

Links:
https://developercommunity.visualstudio.com/content/problem/982029/azure-devops-add-on-crashes.html

Problems with Excel AddIn for Azure Devops for Visual Studio 2019

A couple of days ago I reinstalled my computer and since I usually go by “Newer is always Better” I installed Visual Studio 2019. When I was going to generate release notes for our latest release Excel Addin for DevOps did not work. I looked through the prerequisites and found nothing I missed… It should work… WTF

Well… after some research I found this forum post online saying that apparently there is an issue with Excel Addin included in the latest version of Visual Studio. The correct version is here: Azure DevOps Office® Integration 2019

Links:
https://developercommunity.visualstudio.com/content/problem/776394/issue-with-azure-devops-open-in-excel.html

Uninstalling Excel Addin

This one was an annoying one…

I had to help a customer uninstall the Excel addin for Dynamics 365 for Operations. This should be a simple task (everything is if you know how to do it). So I went into Excel Add-ins using File – Options – Add-Ins… No Dynamics Excel addin:

WFT!!! A nice person then showed me that there is another place for Excel Addins (obviously)… You go to Insert – My Add-ins… Presto!

/Johan