Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XL Reporter to Excel

Hi all

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

Former Member
replied

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,

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question