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

SAP Bex Analyzer (Netweaver 7.1) Opens workbooks twice when starting.

We just upgraded from bex 3.5 to 7.1, and have set it to open the Analyzer whenever excel starts. But now whenever we open an excel workbook it opens each workbook twice. We have one file in the XLSTART folder that loads in macro's but just opens a blank workbook. The file we are opening has code that sets calculation to manual and prompts the user that it has set to manual.

Whenever we open a file, it promps the user twice about setting it to manual, but only 1 workbooks pops up (because excel only allows one workbook with the same name to be open at a time), but we also get two blank workbooks that open up because the file in the XLSTART folder is being opened twice as well.

Has anyone else seen this problem with workbooks being opened twice, or attempting to be opened twice with bex analyzer 7.1?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 24, 2011 at 08:50 PM

    What version of SAP-GUI are you using ? SAP-GUI 7.2 (latest version) was heavily rewritten using Visual Studio and SAP has stated that certain features that existed in earlier SAP-GUI versions are no longer available (it's Microsoft's Fault). It is also quite possible that your initial launch macro in Excel is causing the problem.

    I would personally recommend that you do NOT launch Bex Analyzer when Excel opens, unless this is your primary method to interact with Bex workbooks and such. That may resolve your issue.

    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.