[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Integration between SAP and Excel 2007

Posted on 2009-04-29
Medium Priority
Last Modified: 2013-12-08
We have been working on a number of issues around the integration between SAP and Excel 2007.  For the most part, these have been resolved by a combination of SAP notes and Office 2007 diagnostics.  However, theer is one, which we cannot consistently replicate whereby having run an ALV report and intiated download to Excel, the excel application opens within SAP and the data is correctly transferred but the Excel Ribbon is not visible nor is the Office button, hence, the user is unable to savel the document as required.  The only workaround in this situation is to use the F12 key to initiate a Save As.

We are running SAP Release ECC6.0 Patch Level 10 with SAPLOGON 7.10.  We are currently running MS Office 2007 SP1 on Windows XP Professional 5.1.2600 SP3 Build 2600

Does anyone have any similar experiences of this condition?

Many thnaks,
Question by:TimBurraston
  • 2
LVL 39

Expert Comment

ID: 24263399
Did you try using Ctrl+F1 to display the ribbon?


Accepted Solution

Twisteddk earned 1500 total points
ID: 25293175
Yes, this is/was a known bug in certain sapgui versions. You'll likely notice that the context menu is also gone if you right-click with your mouse. AFAIK, it should be adressed in some patch version of the GUI (or ECC ?) I'm not sure of which. You can likely find decent references to this problem on sapnet, http://service.sap.com/notes

Author Comment

ID: 25381172
Twisteddk, many thanks for this.

Author Closing Comment

ID: 31575991
It would be useful to know specifically which GUI versions have the issue.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question