ALV to EXCEL Problem

[Former Member]

Hi frnds,

when i am trying to export the data from ALV to EXCEL some columns are not exporting... its surprising me.. can u give any solutions why system is not exporting all columns to excel?

points will be rewarded for helpful answers.

regards,

balu

[Simha_]

Hi,

Check the field catalog that u are passing to downloaad function module.

or check in the debuging mode..

U might get a clue..

Cheers,

SImha.

[Former Member]

Hi,

I think u are not having some authorizations.

Regards,

Nandha

[Former Member]

change these options in excel sheet and checkout if it can help u

1. Go to Tools -> Macro -> Security in Excel

2. Select the ‘Trusted Sources’ tab and ensure that the checkbox titled ‘Trust access to Visual Basic Project’ is ticked.

3. With the feature switched on, the data is passed to Excel.

[Former Member]

Check with like :

Click on local file -> select spreadsheet option

give the file name like as .txt and save it local desktop.

now open .txt file and see the content,even if you missed then problem might be code .

if it is okay -> right click text file -> open with xls file

I just downloaded the data into xls as well txt file and it is working well

Thanks

Seshu

Thanks

Seshu