Excel opens additional spreadsheet and displays data in gui screen

[daniel_parris]

All,

Recently all Microsoft Office software was upgraded from Office 2003 to Office 2007 at our customer sites. The issue that is occurring after the upgrade is as follows:

1. User executes a z-transaction code that runs a BCS report

2. They enter the criteria and start a report in the foreground.

3. Excel 2007 launches without a worksheet.

4. Report finishes and the data is displayed within the gui screen.

This issue occurs for only 1 of our customer sites (effects various users, not just one) which tells me it is not related to code in the z-transaction. I have been unsuccessful reproducing the issue myself. I have searched SDN and for SAP notes for a solution, but have not found anyone with the same issue.

At first the users were getting a macro security popup, so I instructed the users to set their macro settings per SAP Notes 1094693 and 696069. I also instructed the user click the u201CTrust all from publisheru201D button. The Macro security popup is of course gone, but Excel still opens; which is annoying the users.

Here is some info on our environment:

1. SAP ERP 6.0 Enhancement Package 3 SR2 (Support Package Stack 13, Kernel 201)

2. Solaris 10 and Oracle 10.2.0.2

3. SAP GUI 7.10 Patch 5

4. Excel 2007

5. Windows XP

Not sure if this is GUI related (all client sites have the same patch level), another Excel setting, or maybe a configuration difference (MS Office group policy?) on the computers at the effected location versus all other customer locations.

Does anyone know what we can do to stop excel from opening at all and just display the data inside the gui screen?

Any help will be greatly appreciated.

Thanks!

-Daniel Parris

[Former Member]

Upgrade the GUI to at least 7.10 patch 11.

Moderator message - And welcome to SCN.

Rob

[daniel_parris]

Hey Rob,

Thanks for the quick reply. Upgrading the gui to all our customers is a huge ordeal. Though I could try just upgrading one of the users affected.

I do not think the issue is gui related since SAP GUI 7.10 Patch level 5 is what I have tested with (same as the user) and been unable to reproduce the issue and no other customer sites have reported the issue.

Any other ideas besides updating the GUI?

Thanks!

-Daniel

[Former Member]

I would first upgrade the GUI for one of the problem users to see if that works.

Rob

[daniel_parris]

With some testing, I was able to determine the issue occurs due to the parameter ID "G_RW_DOCUMENT_TYPE" with value "XLS PR-". I did some searching but could not find much info on the different parameter ID's and the different values you can set for them.

Removing the parameter keeps excel from opening, but the looks of the inplace spreadsheet changes.

Anyone have any info on this parameter ID?

Thanks!

-Daniel