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

Bex Analyzer installation and Excel 2010 security options

Dear all.

I'm installing Bex Analyzer 7.3 with the latest packages available on the market place and the Bex toolbox is not working at all.

Here is my config :

Win7 Enterprise

Office 2010

SAPGui 7.3 FEP 3

BexAnalyzer 7.3 SP 201

In fact my company has set the Excel security options in such a way that the "Trust access to the VBA project object model" is grayed out unticked.

It seems to cause the Bex toolbar issue because the Add in is not able to install correctly.

I'm sure we are not the only one having set this security option like this.

Do you know if there's a way to install correctly the Bex with the option unticked ?

Thank in advance for your help.

Emmanuel

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 14, 2016 at 03:47 AM

    Hi,

    please follow note 1437575 and get the trace file. My problem is similar to yours. When I click open button, it has no responding. My trace file shows BExAnalyzer.xla under directory C:\Program Files (x86)\Common Files\SAP Shared\BW is not trusted by Office Excel, so I added it as a Trusted Location into Excel in Trust Center, so the problem is ok.

    Have a try.

    Zhihua

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 16, 2013 at 01:31 PM

    Hi Emmanuel,

    Can you please apply BI 7.0 ADDON FOR SAP GUI 7.30 Patch Level 100 and check whether it helps you.

    Did you mean that you have unticked the option for "Trust access to VBA project object model"?

    Please also refer the following note only with regard to the option "Trust access to VBA project object model":

    1712264 - BExAnalyzer: On Refresh the BEx dispaly VB project failed

    Thanks & Regards,

    Sapna

    Message was edited by: Sapna J Gurudutt

    Message was edited by: Sapna J Gurudutt

    Add a comment
    10|10000 characters needed characters exceeded

    • Emmanuel

      I should also have added that while my immediate connection issue has been resolved, I have now found that some BEx Analyser reports launch without issue from the menu, others immediately prompt to be saved before closing. The BEx custon toolbar does not appear for these reports, but does for others??

      Regards

      Sean

  • author's profile photo Former Member
    Former Member
    Posted on Mar 21, 2013 at 09:10 AM

    Hi Experts,

    i'am facing the same problem.

    the bex anlayzer toolbox is not working after installing the latest patches for bi frontend sp200!

    And i get this errormessage to:

    Environment:

    Windows 7 Professional

    Office 2010

    MS Net 4.5

    SAP GUI 7.30 SP3

    SAP_BW 702 SP11

    the bex analyzer only worked as i let it unpatched, or with patch BI730SP01_100*.

    When we install the latest BI Frontendpatch, the bex analyzer is not working correctly.

    I would really appreciate some help solving this problem with the bex tool.

    br

    Julius


    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.