Excel Add-In: Doesn't Stay Enabled

Under heavy load it is possible that the Excel Add-In may crash whilst executing some activity. In this event it is quite likely that Excel will disable it to prevent it impacting system stability.

It is usually possible for the user to re-enable the Add-In by:

Starting Excel
Going to “File->Options” – and then selecting the “Add-ins” item on the lefty hand side
Select "COM Add-Ins" from the Manage box highlighted and click "Go"
This display another dialog which includes the FastClose Add-In, check the box next to it and FastClose should be enabled.

However - even then it is possible that the next time Excel is launched the add-in is disabled meaning the whole process has to be done again.

This problem is caused, and can be reasolved, by a registry setting

Open Regedit and navigate to the folder HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\FastClose.ExcelAddIn
Within this folder is a setting called LoadBehaviour - this should be set to 3. Values as a whole as follows:

Option	Description
0	The Add-In is disabled. Users can enable the Add-In temporarily by activating the Add-In in the COM Add-In dialog box.
1	The Add-In is enabled. This temporary activation means that the Add-In is disabled again when Microsoft Excel is closed.
2	The Add-In is disabled. Users can enable it in the COM Add-In dialog box. This sets the value to3.
3	The Add-In is enabled. If required, users can disable it in the COM Add-In dialog box. This sets the value to 2.