Current set up: Windows 10, MS Office 2016, Azure DevOps Office Integration (free) 2017.
I have been using the add-in for almost a year now to export TFS queries and work items for a vendor since they do not have access to our TFS project. It has always been somewhat glitchy but worked for the most part. Today, I am completely unable to connect and access my TFS project because excel crashes every single time. The Team ribbon was disappearing from my excel menu items so I updated the registry, yet every time I try to access my project excel still crashes and I get the following errors: "Excel is running into problems with the 'tscofficeshim.connect.15' add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?" I'll click no, and get this error: " Excel is running into problems with the 'team foundation add-in' add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?" I click no again, and run through the same loop. I also tried to update my Azure DevOps Office Integration to the 2019 version but when I try to download through this page: https://visualstudio.microsoft.com/downloads/ , I get the following error in all browsers:
Secure Connection Failed An error occurred during a connection to go.microsoft.com. SSL received a record that exceeded the maximum permissible length. Error code: SSL_ERROR_RX_RECORD_TOO_LONG The page you are trying to view cannot be shown because the authenticity of the received data could not be verified. Please contact the website owners to inform them of this problem.
Posted on MS forum and awaiting Azure help desk ticket assignment, figured I’d post on here too since it seems to be a fairly common issue for others.
Would appreciate any guidance.