Solution Properties
Solution ID:
220924160100882
Last Modified Date:
Fri Mar 03 12:37:37 UTC 2023
Taxonomy Path:
Category//Reporting
Author:
[email protected]
An error occurred trying to refresh Excel's links to its installed add-ins. The error was (unable to set the installed property of the add-in class)
Description
Cause

While trying to run a report, an add-in may be disabled

Resolution
  1. Add the Common Files Folder to the Trusted Sites
  2. Go open blank Excel file
  3. Click on File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location > --> Browse to 'C:\Program Files (x86)\Common Files'
  4. Click on OK
  5. Click on 'Subfolders of this location are also trusted'
  6. Click on OK
  7. Verify if the "Report Designer Add-In (Custom Task Pane Helper)" is enabled
    1. Open Excel > Options > Add-Ins.
      1. "Report Designer Add-in 1.2.0"
        1. Type="Excel Add in", and
      2. "Report Designer Add-in 1.2.0 (Custom Task Pane Helper)".
        1. Type="COM Add-in"

8. If the Report Designer Add-in 1.2.0 and the Report Designer Add-in 1.2.0 (Custom Task Pane Helper) are not showing in the Active Application Add-ins list, check to see if they are disabled.

9. Scroll down to the bottom of the Add-ins panel and see if they listed in the Disabled Application Add-ins section. If they are disabled, then scroll to the bottom of the screen to the Manage section and select Disabled Items and click Go. Then re-enable them.

10. If they are not disabled, scroll to the bottom of the screen to the Manage section and Select Excel Add-ins from the Manage drop down list and click Go.

11. If the Report Designer Add-in 1.0 is listed, check the box.

12. If the Report Designer Add-in 1.0 is not listed, click Go at the bottom of the window to Manage Excel add-ins, then push browse and browse to: C:\Program Files\Common Files\BIExcelFunctions. Select either 32bit or 64bit (depending on what version they are running) then select Sage.BI.ExcelFunctions.dll and click OK

Note: when the Report Designer Add-in 1.0.0 is selected the Report Designer Add-In 1.0.0 (Custom Task Pane Helper) should be dynamically selected. If it is not listed, click COM Add-ins from the Manage drop down and click Go and If Report Designer Add-In 1.0.0 (Custom Task Pane Helper) is on the list check the box

13. Close Excel and go back to Sage Intelligence/ Reports/ Report Manager and run the report again.


[BCB:155:Chat 100 US:ECB]

Steps to duplicate
Related Solutions