ALV-GRID Excel-template

[Former Member]

Hi,

we offen use the ALV-GRID with EXCEL-Layout.

In this layout you can Copy the sheet, print etc.

But a lot of Function are grey and cannot be used.

We want to send the excel-sheet via EXCEL-Button

as an email.

Question: is it possible to set this function

as useable?

thanks for Help

Regards, Dieter

[Former Member]

Hi,

we offen use the ALV-GRID with EXCEL-Layout.

In this layout you can Copy the sheet, print etc.

But a lot of Function are grey and cannot be used.

We want to send the excel-sheet via EXCEL-Button

as an email.

Question: is it possible to set this function

as useable?

thanks for Help

Regards, Dieter

[former_member306743]

Hi Dieter,

unfortunately I can't help you with your problem,but I really do need your help since you say you often use Excel layout in ALV: I'm trying to use one of the two excel templates for the ALV display of the standard report RFBILA00;I manage to get the excel view but there is no data in the excel view...(I've also set the excel security level for macro on low)

Can you help me please?

Thanking in advance ,

Laura

[Former Member]

Hi Giovanni,

i have try it with RFBILA00 and had no Problems.

Do you have all times this problem or only with

RFBILA00? Perhaps its an authority Problem.

When you execute it, try tcode su53.

regards, Dieter

[Clemenss]

Hi Dieter,

it is true: For many SAP modules the codes are inactive.

Sometimes it works entering &VEXCEL or &XXL in the command line.

Otherwise: If no exitv is available to set your own status including active &VEXCEL or &XXL, it is a modification.

It depends if SAP uses standard or non-standard ALV functions.

Regrads,

Clemens

[Former Member]

Hi Clemens

thanks for your answer.

I tried &VEXCEL, but it has the same result. I get

the excel-sheet, but i'm not able to send this

as an email (i looks grey).

Regards, Dieter