Sage Intelligence Add-in giving error or not showing up in Excel
Problem:
When running Sage Intelligence requiring the Excel add-in, an exception error is shown to the user, or the add-in does not show up in Excel
Reason:
The likely reason for this problem is that the Excel Add-in is not registered correctly.
Resolution:
To fix this problem, the Excel Add-in for the report designer needs to be enabled in Excel.
- Open up the hosted Microsoft Excel, then navigate to File -> Options
- Click on "Add Ins", then select the "COM Add-Ins" and click "Go". In the resulting Window, make sure that the report designer is checked. If it is already checked, uncheck it, click ok, then reopen the "COM Add-Ins" and recheck it again, then click ok.
Please note that if the Report Designer Add-in does not show up in the "COM Add-ins" screen, you can add it, by click on the "Add..." button, then navigate to: C:\Program Files (x86)\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunctions.dll
- Now, open the "Excel Add-ins" from the dropdown, then click "Go...", then make sure that the Report Designer Add-In is checked. If it is already, uncheck it, click ok, then reopen the "Excel Add-ins", and recheck it, then click ok.
Now, the Sage Intelligence Add-In should load up correctly.
Related Articles
The Report Designer Component is required by this report and is not installed on this workstation
Problem When you try to run the Report Manager from Sage Intelligence reporting module in SAGE you get an error "The Report Designer Component is required by this report and is not installed on this workstation" Why Is This Happening? Report manager ...How to enable F9 COM Add-In in MS Excel
Why does this happen Sometimes the F9 Com-Add in doesn't load properly or the user mistakenly disables it. How to enable it Please follow the below instructions Open Microsoft Excel Open a new Blank workbook Click Options ...Emailing from QuickBooks, Sage, Misys and other Applications
General Guidelines gotomyerp has tight security around all incoming and outgoing traffic, and will require a request from all clients with pertinent information, to allow email traffic through the firewall. Please note that by default, ports 587 is ...Excel prompts for FileBridge Credentials
Problem When opening an office file (Excel, Word etc.) you get prompted for your FileBridge credentials. This will often happen after a password change. Solution 1 Click on the Windows icon in the taskbar and start typing "Credential Manager" and ...ADVISORY: Microsoft Update Causes Excel Export Error on MISys
UPDATE: October 17, 2017 Microsoft has identified this as an issue with a recent Windows update, and are working to resolve it, For more information, you can view this article from Microsoft. They will provide an update in an upcoming release to ...