Skip to Content
avatar image
Former Member

XL Reporter Security error

Hi all,

I looked at the previous threads regarding the error recieved when running XL Reporter with Excel 2007.

I followed the tips but I am still getting the same error. I am on SBO 2007 PL30. I uninstalled the client and re-installing it but it still gives the same error....

Any suggestions???

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 03:05 PM

    Dear Noor,

    Please check the Security settings once more. In addition to

    SAP note 853821, please follow the steps below (slightly different to steps

    in the note):

    1) Open Excel

    Tools-> Macro-> Security-> Trusted Publishers tab

    On the Trusted Publishers tab:

    -> Untick Trust all installed add-ins and templates.

    -> Tick Trust access to Visual Basic Project

    2) Close Excel

    3) Open Excel

    -> You should have a security warning 'contains macros' by

    Microsoft Corporation

    Tick-> Always trust macros from this publisher

    and

    click-> Enable Macros

    4)Open from Excel

    Tools-> Macro-> Security-> Trusted Publishers tab

    and

    Tick -> Trust all installed add-ins and templates

    Please go back in again to make sure that the settings take effect as

    sometimes they do not.

    Also in the macro security use the security level Low or Medium.

    At the same time check the SAP note 853343.

    Also please refer to the following link to get the details information of the above settings in excel 2007.

    http://office.microsoft.com/en-us/excel/HP100968341033.aspx?pid=CH101020

    751033#COMAddIn

    Regards,

    Rakesh pati

    SAP Business One Forum Team

    Add comment
    10|10000 characters needed characters exceeded