Skip to Content
author's profile photo Former Member
Former Member

XL reporter Error

Hi all

XL reporter giving error"Required COM Add in program for XL reporter has not been loaded and prohibit microsoft excel from running."

How to solve this problem

Thanks

Neetu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 06:55 AM

    Please check SAP notes 843566. Simply by running a ComaAddIn regstration file under administrator right. Problem will be solved

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2008 at 07:04 AM

    Dear,

    About the issue you reported,please kindly refer to

    Note 893307 and 853343 for solution.

    In case the procedure mentioned in the Notes does not

    help,please try to re-install the XLR on the machine.

    To perform a clean re-install of XLR, the following steps are necessary in addition to the normal uninstalling process of Business One add-ons:

    1) Delete the database IXMetaSBOOEM on the server;

    2) Delete all tables begin with 'ixt' in the customer DB;

    3) Open windows registry editor, click on the root node of the registry

    (My Computer), search for the term 'SAP XL Reporter', and delete all

    keys and their sub keys found by the search.

    4)Delete or rename the SM_OBS_DLL folder under %temp%

    Hope that could solve your issue.

    Regards

    Apple

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 07:22 AM

    hi,

    uninstall the XL reporter and install using the following steps

    installation steps of XL-reporter add-on,

    1. goto add-on administration => Register Add-on(click).

    give the XL reporter address. select default group as Manual.

    update.

    2. goto addon manager => pending Add-on tab => select the addon row and install.

    in installation give the user id and pwd of SQL server.

    3.goto addon manager =>installed addons tab, start the XL reporter, once it get connected as status.

    4. go to tools menu in SAP B1, in that you will find XL reporter, click that XL reporter will open.(to view XL reporter)

    follow the above steps you will get the XL repoter add-on running in SAP B1.

    regards

    sandip

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 06:42 PM

    Please check the following to get the cause of the error message :

    1. The report writer COM Add-in has not been loaded, which prohibits

    Microsoft Excel from running.

    2. The user should be an administrator on the local machine to add COM

    add-ins.

    Please follow the steps as the the attached note : 853343

    to resolve the issue.

    Also see the notes Also please refer to the SAP notes : 853821 and 924561.

    Regards,

    Saurabh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.