Sage 200 Professional - Sage BI add-in missing from Excel.

You may encounter Unable to run report messages when trying to generate reports through Business Intelligence. 
On top of this, the Sage BI add-in may be missing from the Excel ribbon and, if you try to reselect the Sage BI add-ins through Manage COM Add-ins in Excel, the selection is not retained.

This problem can occur when the COM Add-ins for Sage BI are disabled, but when enabling them through Microsoft Excel, the setting is not retained.

Try the following steps to resolve this problem:

1. Open the Registry Editor and navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
2. Highlight IAReportLib.Report and, in the right-hand pane, right-click and choose Modify on the LoadBehavior entry.
3. In the Value data field, change the number to 3 then click OK.
4. Carry out steps 2 and 3 again for IAXCalcVis.IACalcVis.
5. Right-click on IAReportLib.Report in the left-hand pane and choose Permissions.
6. On the Security window, add the affected user(s) and tick Full Control, then click OK.
7. Carry out steps 5 and 6 again on IAXCalcVis.IACalcVis.
8. Close the Registry Editor down and restart the PC.

If the registry entry reverts back to having a LoadBehavior of 2, after restarting the PC, further investigation will be required by the IT admin.