Problem with ALV Grid

[Former Member]

HI,

I am working on ECC 6.0.

In one of my report using ALV Grid ,It is showing me perfact output.

When i am trying to view in Excel Format via Views -> Microsoft Excel , i am not able to view same output in Excel format.

can anybody let me know the reason behind it ?

[Former Member]

Hi,

Can you explian how it is varying from Output to Excel sheet? Where exactly? can you give more details?

Regards,

Satish

[Former Member]

I am not downloading into Excel but I just want to have look in Excel format instead of ALV Grid.But i am not able to view.

[naimesh_patel]

Yes, it happens when you have mixture of charachter fields and quantity/amount fields. System downloads Charachter fields first and than amount fields.

So, to download use.. Local File (CtrlshiftF9)... select the spreadsheet... choose your locaiton to download.

Regards,

Naimesh Patel

[Former Member]

Hi,

My downloading part to Excel is working.It shows all data in Excel which i can see in ALV Grid.

But when i am switching my output view frm ALV to Excel , i cant see data in Excel.It is just blank...

What could be reason behind it ?

[Former Member]

In Excel:

Tools -> Macro -> Security;

select the ?Trusted Sources? tab;

ensure that the box ?Trust access to Visual Basic Project? is checked;

click OK.

Exit Excel.

For some SAP standard reports with an Excel view, Excel security needs to

be relaxed further.

In Excel:

Tools -> Macro -> Security;

select the ?Security Level? tab;

ensure that the radiobutton ?Medium? is selected;

click OK.

Exit Excel.

<a href="http://sap.ittoolbox.com/groups/technical-functional/sap-dev/alv-excel-not-working-1268908">Based on John_MacNeill post at ittoolbox.com</a>

[Former Member]

Hi regula,

Your answer was perfactly right.

Now i can see Excel view .

But i dont get the perfact reason behind it ?

can u plz let me know about this ?

[naimesh_patel]

I have tried this also and it is working for me.

This happens because of the MACRO security. Excel handle macros very sensitivly. The macors in the SAP > Excel conversion has medium security so, we need to make that setting.

Regards,

Naimesh Patel