XL Reporter to Excel

[Former Member]

Hi all

What are all the settings that have to be on Excel to generate report in Excel from XL Reporter.

[former_member186095 · Accepted solution]

Hi,

This SAP note is the one things to set if you want to run XL reporter and edit the report in the MS. Excel:

XLR - Error with security settings in Excel
Symptom
When trying to edit, create or run a report definition I get the error message 'Security settings in Microsoft Excel prohibit XL Reporter to run'. I have checked note 853821, but the error message still appear.
Other terms
SBO, Addon, Add-On, VB, Visual Basic, Office, macro, Business One, reporting
Reason and Prerequisites
XL Reporter is a Visal Basic application and needs some necessary componenents to run VBA macros. In Microsoft Excel, look under Tools -> Macro and check if the 'Visual Basic Editor' is available or deactivated. If deactivated, this is probably because Visual Basic for Applications in Office are not installed.
Solution
Install Visual Basic for Applications in Office.
(This description is for Office 2003 and may vary depending on Office version)
In Windows, go to Start -> Control Panel -> Add/Remove programs. Find Microsoft Office 2003, select it and choose Change.
In the Office 2003 setup window, choose Add or Remove features and choose Next.
Check the box "Choose advanced customization of applications" and choose Next.
Expand the line "Office Shared Features", scroll down and choose the dropdownbox for Visual Basic for Applications and choose Run from My Computer.
Choose Update and wait for the installation to finish. Choose OK when a message saying that Office 2003 has been updated successfully appears.
Check that all settings are according to note 853821 and start XL Reporter. You should now be able to run or edit reports in Excel.

here is the 2nd:

Unable to load Excel COM add-in for XL Reporter as user
Symptom
The user get an error message "A required COM add-in program for XL Reporter has not been loaded and prohibits Microsoft Excel from running." when trying to open a report definition.
Other terms
XLR, XL Reporter, Excel, COM add-in, administrator
Reason and Prerequisites
You need to be an administrator on the local machine to add COM add-ins.
Solution
The user should be added as a member of the administrator role on the local computer the first time you start Excel from XL Reporter the first time so that the COM addin are registered, then you can remove the user from the administrator group again.

let's know if it still can't run.

Rgds,

[Former Member · Accepted solution]

thank you

[Former Member]

In the Ms excel goto > tools>macro>security and in the security level tab set it to low option.In the Trusted sources tab check both the options trust all installed add-ins and templates and trust access to visual basic project.