Invantive Control for Excel is not one add-in but two, and they fail in different ways: - the COM add-in "Invantive Control", file `Invantive.Excel.Starter.vsto`, which draws the [[Invantive Control for Excel/User Interface/Control Ribbon|Control ribbon]] and the [[Invantive Control for Excel/User Interface/Modeler Ribbon|Modeler ribbon]]; - the Excel add-in "Invantive Control Functions", file `Invantive Control functions.xlam`, which holds the [[Invantive Control for Excel/Formulas/Formulas|Excel formulas]] and the [[Invantive Control for Excel/VBA Procedures/VBA Procedures|VBA procedures]]. The `.xlam` lives in the add-in folder of Microsoft Excel, by default `%USERPROFILE%\AppData\Roaming\Microsoft\AddIns`. Which of the two is missing follows from the symptom: no ribbon means the COM add-in did not load, while a ribbon with formulas returning `#NAME?` means the `.xlam` did not. ## The Ribbon Is Not Shown Microsoft Excel keeps a list of add-ins and has several mechanisms to stop an add-in from causing trouble. Those mechanisms are prone to over-reacting: a crash of Excel, or shutting it down while Invantive Control for Excel was busy, can be enough for Excel to disable the add-in permanently. The tick box in "File", "Options", "Add-ins" then still shows it as enabled while it is on the disabled list elsewhere. Repairing this by hand means editing several places in the registry, which is why [[Invantive Support Assistant/Invantive Support Assistant|Invantive Support Assistant]] exists. Its "Enable Invantive Control" walks the mechanisms in order. Restart the device first when the assistant itself does not come up, close every Microsoft Excel window afterwards, and check in Task Manager that no `EXCEL.EXE` remains before starting Excel again. ## The Formulas Are Not Registered - `itgencuy015`: the Excel formulas could not be installed. The `.xlam` add-in could not be activated. - `itgencuy003`: the `.xlam` could not be added to the list of add-ins, because there is no active Protected View window. This is seen on the first start of Microsoft Excel after an upgrade. - `itgentan002`: the formulas could not be registered; the macro `I_RegisterCallback` cannot be run. The message itself names the remedy: enable "Invantive Control functions.xlam" under "File", "Options", "Add-ins", close every Excel window and end any remaining `EXCEL.EXE` process. A cause which is easily missed here is the Trust Centre. When the add-in folder is not a trusted location, Microsoft Excel loads the `.xlam` but disables its macros, upon which the formulas resolve to `#NAME?` and pressing Enter in such a formula raises a security warning naming the path of the `.xlam`. Add the add-in folder to the trusted locations in "File", "Options", "Trust Center", "Trust Center Settings", "Trusted Locations". Where the formulas are registered but not recognised, [[I_RegisterFunctions]] and "Reregister VBA Integration" on the Control ribbon do the registration again. ## The XLAM Is Replaced at Every Start `itgenuty689`, together with a slow start, means the `.xlam` is being written afresh each time Microsoft Excel starts. Remove the file `Invantive Control functions.xlam-sig` from the add-in folder and install the current release. The replacement also fails intermittently when another `EXCEL.EXE` still holds the file. ## The Installation Itself Fails An installation which reports that `Invantive.Excel.Starter.vsto` cannot be found under `C:\Program Files (x86)\Invantive Software BV\` has not completed. Install the current release from the download site rather than repairing this by hand; installers which stop without a message are usually blocked by SmartScreen or by an installation policy. Where the add-in has to live somewhere other than the default folder, the environment variable `INVANTIVE_CONTROL_XLAM_FOLDER` moves it; see [[Office Add-ins]].