Sage Intelligence Report Designer add-ins not responsive

1. Ensure the User Account Control (UAC) is turned off

Windows 7

• Select Start > Control Panel > User Accounts
• Select Change User Account Control Settings, ensure the slider is at the bottom on Never notify

Windows 8 and Windows 10

• Select Start button > Search for UAC

• Select the option Change User Account Control settings

The User Account Control Settings screen will display, ensure the slider is at the bottom on Never notify

1. Ensure you have the desktop version of Microsoft office installed

• Navigate to your control panel
• Select Programs and Features
• Ensure your Microsoft office package displays

1. The Sage Intelligent components are corrupted or missing

3.1 Uninstall Sage Intelligence

• Navigate to your Control Panel
• Select Programs and Features
• Highlight Sage Intelligence (Ensure you have selected the correct version i.e. V19)
• Select uninstall and the top of the window
• Navigate to C:\Program Files (x86)\Common Files
• Rename the following files to OLD
  • BIComponents
  • BIComponentsDotNet
  • BIExcelFunctions1.1
  • BIGenerator

3.2 Reinstall Sage Intelligence.

• Click Here to download the latest version of Sage Intelligence
• Select the Accounting Cross Sell product tab
• Select the correct Sage Intelligence download i.e. Partner or Xpress depending on which product you are running
• Once downloaded run the installation

1. The BI generator and tools are missing in Excel
   1. Excel
   • Open Excel on the computer you are trying to run the report but get the error message
   • Select File > Options > Add-Ins. You will note that the BI Generator is not showing in the list below

Disclaimer:

This solution requires advanced knowledge of your computer's operating system.

Contact your system administrator for assistance.

Modifying your Windows Registry incorrectly can severely affect system operations.

Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.

4.2 Registry Editor

• Select Start > Type in regedit in the search column
• The Registry Editor will open
• Select > HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

• Right click on Addins > New > Key
• Type in BIGenerator, in the space provided on the left-hand side

• Open Excel
• Select File > Options > Add-Ins to ensure the BI Generator is showing

• If the generator is not showing select COM Add-Ins
• Select GO
• Select the BI Generator

• Select OK

NOTE: Should the ablve solution not work please leave a comment and explain where you got stuck or what you did. In this way we can check the solution and amend if need be.