Sage Intelligence Error - An error occurred trying to refresh Excel's links to its installed add-ins.

Summary

ERROR: 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) when trying to run a report.

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 
  • Open Excel > Options > Add-Ins
    • “Report Designer Add-in 1.2.0”
      • Type=”Excel Add in”, and
  • “Report Designer Add-in 1.2.0 (Custom Task Pane Helper)”.
    1. Type=”COM Add-in”