problems excel view in ALV

[Former Member]

Hi,

I am displaying data through an ALV_LIST_DISPLAY.

When I click on the Microsoft Excel at the ALV toolbar to view the same data in excel sheet it does open the excel sheet WITHOUT ANY DATA.

I changed macro options in excel and nothing happened

[Former Member]

Hi,

I am displaying data through an ALV_LIST_DISPLAY.

When I click on the Microsoft Excel at the ALV toolbar to view the same data in excel sheet it does open the excel sheet WITHOUT ANY DATA.

I changed macro options in excel and nothing happened

[messier31]

Normally we dont have to write any code for getting data in ALV's Excel inplace View. It is taken by SAP itself.

check out if u r using

it_events = gt_events[]

if u r not using any custom event then just comment this parameter of ALV_LISTDISPLAY and test whether the data is getting populated in excel..

Let me know the result...

Enjoy SAP.

Pankaj Singh

[Former Member]

I am using it_events = gt_events[]

[messier31]

Can just comment

it_events = gt_events[]

for a test run and check if data is coming in excel inplace view...

[Former Member]

Sorry, I was wrong, I use FM REUSE_GRID_DISPLAY

[messier31]

No issues jose..both FM have

it_events = gt_events[]

comment it once and do a test run

[Former Member]

Hi Pankaj,

I am also having same problem . I hv commented out it_events = gt_events[] and tried but same prob. Giving warning message from xl as "Thsi workbook has lost its VBA Project, ActiveX controls and any other programmability- related features. If i poress on the OK button then it opens xl sheet but without any data. Why itis happening , any idea?

Thanks in Adv,

Cheers

[Former Member]

Hi,

Me too facing the same prob then i took alternate method List->Export->Local File->Spread Sheet->File Path & File Name-> Generate. U may use this method if client is ready to accept that.

Cheers.

[Former Member]

I had the same problem and solved it by changing the security->trusted publishers setting in EXCEL... select both 'Trust all installed add-ins...' and 'Trust access to Visual Basic Project'.