Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

facing problem while downloading ALV grid Output into Excel

Former Member
0 Kudos

Hi Guys,

I am facing problem while downloading ALV grid Output into Excel.

It is downloading into excel, but all character columns first and next all quantity columns it is displaying. But I need columns order as it is in the grid.

If I take all columns as characters it works fine. But it will be problem for calculating total, subtotals of quantity columns

Can someone help me regarding this

thanks for your help

1 REPLY 1

Former Member
0 Kudos

Hi,

Open up Excel on your desktop. Goto Tools > Macro > Security.

Make sure that your security is set to Medium (or less). SAP uses OLE automation to run the Excel instance and in Office 2003 (for example), Microsoft has increased their default security setting to High. With the High setting, the output to Excel fails.

Was this your problem? Don't forget those points, either.

check with this wetther it is solved or not.

Regards,

sana.