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

Excel Inplace Functionality with MS Office Excel 2007 and SAP GUI 7.10

Hi All,

although there are many Excel threads my problem seems to be a bit different so I start a new one - hope this is ok.

We use SAP GUI for Windows 7.10 patchlevel 3 for our SAP NW 2004s and since we updated from Excel 2003 (Win XP) to Excel 2007 (Win Vista) we experience the following problem:

Whenever we try to show a list (e.g. out of transaction sq01 or se16, ...) in Excel format using the Excel Inbound functionality the Excel Grid is opened in the existing SAP window but the Grid remains empty.

Not even the header line of the table is displayed as I read in many other postings here and there is also no error message displayed.

When we use the more complicated way via the XXL object from the menu Export -> Excel Spreadsheet -> Table ->..... Excel is opened in a new window and the data is exported without any problems.

Just the Excel inbound function which would be much more comfortable doese not work any more.

Do you think that an upgrad of our SAP GUI to the latest patchlevel 13 would resolve the problem or is there any other issue in combination with MS Excel 2007 and Vista?

Many thanks for your appreciated feedback in advance and best regards

Günter

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 Jun 12, 2009 at 03:11 AM

    Hello,

    I hate to ask this question, but did you check your MS Excel 2007 Security Options?

    1) MS Office Button >>Excel options (at the bottom).

    2) Trust Center>>Trust Center Settings>>Macro Settings.

    3) Enable radio button (Enable All macro's ( not recommeded;potentially dangerous code can run).

    4) Check the box called Trust access to the VBA project object model.

    Note Number : 1094693

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2009 at 05:04 PM

    Gunter,

    There are many isues wiht MS Office 2007 and SAPGui 7.10 - have you checked SAP notes? I seem to remember one about ALV grids. Some of my users are having issues with Excel 2007 and SAPGui 7.10 patch level 10, and SAP has asked us to upgrade to patch 13.

    Good luck,

    Diane

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 04:45 AM

    Hello Gunter,

    This is a Microsoft issue. You can reproduce this issue without using SAP In-place functionality. This issue occurs with the Office 2007 SP2 (issue not happens in SP1).

    When we embed the Excel in Word and double click on embedded Excel, it will open an empty excel window.

    Thanks and Regards,

    Ashwini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2009 at 11:14 AM

    Hello David,

    I have SP1, it works fine. I again verified in another system having SP1, there also it worked fine.

    Best Regards,

    Ashwini

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi gurus,

      We have configured the options in office regarding the secutiry in macros and VB.

      Sometimes it works when we want to show the data in the excel inplace, clicking on Ctrl + Shift + F7 or in the button. But sometimes not. It is really dificult to reproduce the issue. 90% times works . When it fails we restart the PC or we close all SAP windows or we close the excel application (not inplace excel) and after that it works!.

      Do you have any clue about this behaviour? We are totally lost and maybe during next week we will update our SAPGUI client, currently we are in the 17 patch.

      Thanks guys .

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.