So to be as efficient as possible you’d better have a checklist and this is precisely what this article will be, enumerating all the errors I have encountered describing usual causes and solutions.
Sometimes the root-cause is obvious: you have delivered a new version, but in many cases you will hardly ever know the root-cause of this annoying situation: Windows update, Office update, quick and dirty moving/installation of the addin from a workstation to another one, bad alignment of Uranus and Jupiter…Ī wealth of errors can happen, then it’s hard to have them all in mind, especially when you are in a hurry and with stress you start to get mixed up. So you have deployed your awesome Excel addin in production and all is working fine for some weeks : you are enjoying your success…īut one day the phone rings and the guy at the other side is not really happy no, he is completely upset and you could almost smell his breath when he screams.īut why? Because your awesome addin has stopped working on his workstation without notice. 7 NullReferenceException thrown by the.5 “Error in loading DLL” when compiling the VBA project.