Use VBA to force SharperLight add-in to load
This VBA on the Workbook_Open event will force the SharperLight Add-in to reload
This logic is normally not required but sometimes Excel is automated by various applications such as document management Apps they will fail to take into account that add-ins may be required. Generally these apps will load a workbook with all the add-ins stripped out causing #NAME to appear in cells. If the workbook is normally loaded from the File system the add-in would be present and all would work correctly.
Private Sub Workbook_Open()
Dim c As Integer
For c = 1 To AddIns.Count
If AddIns(c).Name = “md.XLAddin.xll” Then
AddIns(c).Installed = False
AddIns(c).Installed = True
Exit For
End If
Next c
End Sub
Trouble Shooting Missing Excel Add-in
Excel creates registry keys when an add-in is added. The follow are reasons are why the add-in may disappear.
- Excel did not have permissions to create the registry keys (Run Excel as Admin and add the Sharperlight Add-in then close and open again)
- The IT department may have scripts to clear down the users profile on logoff and copy a basic profile on logon which is missing the add-in registry keys
- There is another add-in that doesn’t comply with add-in rules and always assumes it will be the first or last add-in for example. Try adding Sharperlight after this add-in not before. For example Analysis ToolPak has been known to cause issues when it is not the last Add-in in the list.
- In Trust Centre on the Add-ins tab make sure that Disable all Application Add-in is not on
https://msdn.microsoft.com/en-us/library/bb386106.aspx
http://community.spiceworks.com/topic/457676-excel-2013-add-ins-tab-keeps-disappearing-from-ribbon