Skip to Content

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

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???

Former Member
Former Member replied

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

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