SAP GUI 7.2 PL7 Hotfix 1 : Excel Inplace - Worksheet is empty on some PC.

[marek_urban]

Have SAP GUI 7.2 Patchlevel 7 Hotfix 1 on Windows XP @ HP Laptops

Tx: SE16N : MARA : Data in Grid, change to Excel Inplace --> Excel Inplace Worksheet is empty.

In what could it be that no data is displayed?

[jude_bradley]

Hello Marek,

Kindly ensure that you follow the note 696069 No data when view Excel Inplace on ALV with Office 2003/XP

Required settings in MS office XP and MS Office 2003:

To use the Excel Inplace functionality make sure the security settings

for Macro is set to Medium and the option "Trust access to Visual Basic

Project" must be checked on Tools->Macro->Security->Trusted Sources tab.

Required settings in Office 2007:

Please see the video file in attachments of this note.

Required settings in Office 2010:

To use the Excel Inplace functionality, select 'enable all macros' in

Macros settings and the option "Trust access to Visual Basic Project"

must be checked on File->Options->Trust Center->Click 'Trust Center

Settings' button->Macro Settings.

This is required with MS Office XP, MS Office 2003, MS Office 2007, MS

Office 2010.

Be aware that if using Office 2010, only the 32-bit version is supported since SAPGui is also only 32-bit

[Former Member]

Hi Experts!

This is so annoying.

There is any chance that Excel Inplace will work together Office2010 64 bit and SAP GUI 32 bit?

Or we can use only the Excel file export, while SAP doesn't develop the 64 bit GUI?

Regard's

Attila

[jude_bradley]

Hello Attila,

Unfortunately, the present SAPGUI is a 32-bit application and cannot interact with a 64-bit OS.

The next planned release will support 64-bit applications.

BR,

Jude

[Former Member]

Ok. Thank you!

But this is interesting, that SAP GUI not supports the 64bit WIN platforms.

Attila

[jude_bradley]

Hello Attila,

The SAPgui does run on a 64-bit OS (as most applications do),but the interaction between 32-bit SAPGui and 64-bit Office

will not work on an Office Integration level.

From the note 1442028

With Office 2010 Microsoft for the first time publishes a 64bit version of the Microsoft Office package which can be used on 64bit operating systems running on 64bit hardware. In addition to this Microsoft ships a 32bit version of Office that can also be used on 64bit operating systems.

SAP GUI for Windows 7.20 and all related applications including SAP Desktop Office Integration / BI Frontend / BW Frontend do not support Office 2010 64bit, only 32bit versions of Office are supported.

This means that when using 64bit operating sytems with SAP GUI for Windows and related components you have to use a 32bit Microsoft Office version (which is equivalent to the situation before Office 2010 64bit was released).

I hope I have clarified the issue somewhat.

BR,

Jude

[Former Member]

You Right. I was trying to use this function, and couldn't.

64x its not working, but in 32bits its work perfectly.

[Former Member]

Hi Santo,

SAP Note 1908528 - Verifying that Excel inplace functionality is working correctly is quite specific in warning "Ensure that you are not using Office 2010 64bit or Office 2013 64bit".

Cheers,

Dan Mead