COM Add-in Program Required to run XL Reporter

[Former Member]

Dear All,

When I am Opening New (RG23A Part 1) Report in XL Reporter, System giving bellow Error

A Required COM Add-in Program XL Reporter has not been loaded and Prohibits Microsoft Excel from running.

I facing this Error on Server & One Client Also

Operating System on Server = Windows Server 2008 R2 edition 64 bit

Operating System on Client = Windows XP SP 2 - Excel 2003

I am using SAP B1 8.8 PL15

Thanks,

Siddique Shaikh

[Former Member · Accepted solution]

This is the SAP solution to this error, try all steps and it should be resolved.

When we open XL Reporter we 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.

SOLUTION FOR THE PROBLEM:

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.

Manually Loading the XL Reporter Excel COM Add-In

Symptom

If you install Microsoft Office after installing the XL Reporter

application or use another Windows user than the one you used when

installing XL Reporter, you can get an error message.

Reason and Prerequisites

The reason for this is that the report writer COM Add-in has not been

loaded, which prohibits Microsoft Excel from running.

Solution

1. Start Microsoft Excel. If you already have the COM Add-ins command on

the Tools menu, go to step 7.

2. In the Tools menu, choose Customize.

This opens the Customize window.

3. Choose the Commands tab and select Tools from the Categories pane on

the left.

4. In the Command pane on the right, scroll down to the COM Add-ins

command.

5. Select the COM Add-ins command, hold down the mouse button, and drag

COM Add-ins from the Commands pane over to the Tools menu on the Microsoft

Excel men bar. When the Tools menu commands appear, point to where you

want the COM Add-ins command to appear on the menu and release the mouse

button.

6. To close the Customize window, choose Close.

7. On the Tools menu, choose the new COM Add-ins option.

This opens the COM Add-ins window.

8. In the window, choose Add to open the Add Add-in window.

9.Select the IXXLReporter.dll file located in the Client directory in the

XL Reporter program installation area and choose OK.

10. In the COM Add-ins window, select the XL Reporter checkbox and choose

OK.

[kedalenechong · Accepted solution]

Hi All

Any idea why this error still exists even after this IXXLReporter.dll has been registered successfully?

Kedalene Chong

[kedalenechong]

Hi All

My client managed to resolved this error by a few times of uninstallations and reinstallations of SAP Client for 2007B and Micorosft Office 2003.

Kedalene Chong