Solution Properties
Solution ID:
220924660107912
Last Modified Date:
Wed Jul 01 16:49:26 UTC 2026
Taxonomy Path:
Category//Setup and configuration//Users//Preferences
Author:
[email protected]
Fix Sage Intelligence Task Pane not launching error in Excel
Description
Cause

Excel is using the incorrect add-in. The BI add-ins were designed for 32-bit and 64-bit Excel. If the 64-bit Excel is using the 32-bit add-in or vice versa, Excel won’t launch the task pane.

 

Resolution

Remove incorrect Sage BI add-ins

  1. Close Excel.
  2. Open C:\Program Files (x86)\Common Files.
  3. Rename the BIExcelFunctions1.1 folder.
  4. Open Excel, and click OK on all missing add-in prompts until a blank workbook opens.

Confirm Excel version

  1. Go to File, Account, About Excel.
  2. Confirm whether Excel uses the 32-bit or 64-bit version.

Disable incorrect add-in

  1. Go to File, Options, Add-Ins.
  2. Click Go near Manage Excel Add-Ins.
  3. Clear Sage.BI.ExcelFunctions1.1.
  4. Click Yes on the prompt, then click OK.
  5. Close Excel.

Restore and add correct add-in

  1. Open C:\Program Files (x86)\Common Files.
  2. Rename the BIExcelFunctions1.1 folder back to its original name.
  3. Open Excel.
  4. Go to File, Options, Add-Ins.
  5. Click Go near Manage Excel Add-Ins.
  6. Click Browse.
  7. Open C:\Program Files (x86)\Common Files\BIExcelFunctions1.1.
  8. Open the correct folder for your Excel version, either 32-bit or 64-bit.
  9. Select Sage.BI.ExcelFunctions1.1.xll.
  10. Ensure the Report Designer is selected, then click OK.

Verify required add-ins

  1. Go to File, Options, Add-Ins.
  2. Confirm these appear under Active Application Add-Ins:
    • BI Generator
    • Report Designer Add-In 1.2.0
    • Report Designer Add-In 1.2.0 Custom Task Pane Helper

Run the report

Run the report again to confirm the task pane launches correctly.
Tip: Ensure you select the correct 32-bit or 64-bit folder, or the error returns.
Steps to duplicate
Related Solutions