Excel COM Add-in not loaded after using Visual studio performance profiler

101 views Asked by At

My C# Excel Add-in was soft disabled after running the performance profiler of visual studio 2013. Excel displays the following error message:

Load behavior: Not loaded. A runtime error ocurred during the loading of the COM Add-in.

Checking the checkbox in the COM Add-ins Dialog to activate it doesn't work. I've seen similar questions about the add-ins (although there was no mention to the profiler on them) but none of the proposed solutions worked for this case.

Addinional notes:

  • Adding an environment variable “VSTO_SUPPRESSDISPLAYALERTS” with the value 0 to see error details of the error didn't work.
  • Editing the LoadBehavior of the add-in in the registry from 2 to 3 doesn't fix it cause it will gets set to 2 again when Excel starts.

How can I get Excel to load the add-in again? Any tip on how to debug the runtime error?

0

There are 0 answers