Add-in is disabled every time I open Excel

[bergamin]

It worked flawlessly for exactly 2 days. After that, I'm not sure if coincidence or not, I changed my password and it stopped working. After some time, I were able to make it work again, but now I have to re enable it every time I open Excel and even after reenabling it, it isn't recognising tables created by it, probably because it's disabled on startup

I tried a few things:

• Registry (couldn't find the entries mentioned in the articles I found)
• Adding the Add-in location to the trust center thingy
• Reinstalling
• Adding the whole default Add-in folder to the trusted thingy
• Change Office Group Policies (I couldn't find the path to the setting I need to change mentioned in the article I found. Office isn't listed)

I really don't know what else I could be missing. I know my password can't be the issue anymore, because it now works properly when I reenable it

[bergamin]

@snuziale, I found the registry item. It's the following:

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\TFCOfficeShim.Connect.16

LoadBehavior should be 3.

Now, to the actual issue: this AddIn keeps crashing. Even if I create a new Excel file through DevOps, it crashes. If I open a file previously connected to DevOps, Excel crashes. The only way for it not to crash when the AddIn is active now, is with an empty file. But then, When I try to connect, there is no server options to select. When I first worked with this before the crashes, it automatically found my DevOps server

Please, I need help solving this, because WIQL doesn't have aggregate functions and I use all kinds of calculations to help me estimate my work