topic Re: ALV Grid inline excel in Application Development and Automation Discussions

ALV Grid inline excel

Clemenss — Thu, 18 May 2006 09:48:02 GMT

Hi,

I'm convincved this question has been asked and answered but I can't find it:

My report creates an ALV grid using function REUSE_ALV_GRID_DISPLAY. I can use GUI status function &VEXCEL to start excel inline in the grid area. But I get an empty sheet with those many SAP standard tabs - no data are transfered.

As far as I remember this is a BASIS problem but neither our basis people nor I know how to cure this.

Any help is welcome!

Kind regards,

Clemens Li

Re: ALV Grid inline excel

Former Member — Thu, 18 May 2006 10:00:49 GMT

Yes that is not working.

Check this SAP note 548409. may be this will help .

Regards

vijay

Re: ALV Grid inline excel

Clemenss — Thu, 18 May 2006 10:21:04 GMT

Hi Vijay,

sorry, doen't help. I used BCALV_BDS_IMPORT_SAP_TEMPLATE to reimport the templates from client 000 although they should be imported automatically on my release (640 unicode). Still I get the empty template in Excel. I remember this worked at another client.

Mybe someone knows.

regards,

Clemens

Re: ALV Grid inline excel

Former Member — Mon, 26 Jun 2006 10:03:36 GMT

U got any solution... i m facing same problem. we are on ECC 5.0...Rich Heilman where r u??

Message was edited by: kaushal malavia

Re: ALV Grid inline excel

Clemenss — Mon, 26 Jun 2006 12:30:48 GMT

Hi,

sorry, I'm late: I tried as described, logged off and on, and suddenly it worked - for all systems including the one I did not do anything. Looks like a WinXp bug.

Never again any problem.

Sorry, not really satifying - possibly Rich never had this!

Regards,

Clemens

Message was edited by: Clemens Li

Re: ALV Grid inline excel

Former Member — Mon, 26 Jun 2006 13:04:10 GMT

Clemens,

This is an Excel security issue.

Open Excel and from the menu:

Tools > Macros... > Security...

Set the Security Level to Medium.

SAP uses VBA code to pass this info. In newer versions of Excel, the default security is set at High and the SAP code fails to pass the info.

Re: ALV Grid inline excel

Clemenss — Mon, 26 Jun 2006 13:58:40 GMT

Hi John,

I found the sap note earlier. But this was not the reason in our system. We had 'security low' in our excel from begin on.

But it might help!

Regards,

Clemens