topic Re: ALV EXCEL PROBLEM in Application Development and Automation Discussions

ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 10:11:17 GMT

Hai experts,

i am working on sap 4.6c. i created a ALV report , after out put i click on excel file symbol, excel open no data come, what is the problem.

thanks

sitaram

Re: ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 10:51:24 GMT

Hi,

WHEN U CLICK EXCEL BUTTON THE DATA GETS DOWNLOADED INTO EXCEL FILE

Regards,

V.Balaji

Reward if Usefull...

Re: ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 11:24:31 GMT

When u opened ur ALV,

Press CTRLSHIFTF9

Re: ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 12:01:51 GMT

hi,

As an alternative, do the following.

Goto

List --> Save --> excel --> give a filename.xls

I guess this will help you otherwise.

Thanks,

Re: ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 12:14:55 GMT

hai

list-export-excel is ok, its come.

but in tool bar one excel symbol is there , if click that excel is opened with blank and no data come,

thanks

sitaram

Re: ALV EXCEL PROBLEM

Former Member — Sun, 30 Mar 2008 12:21:55 GMT

I guess you missed out to save the file with ".XLS" extension after clicking on the Excel button the output.

Try now saving it with .XLS extension after the filename.

Reward if you're able to get the data

Thanks,

Re: ALV EXCEL PROBLEM

giancarla_aguilar — Fri, 18 Apr 2008 04:01:30 GMT

Hello.

If you're using MS Excel 2007, refer to SAP Note 1094693.

Otherwise, do the ff manually in Excel:

1) In the Excel menu, click on Tools -> Options

2) Click on Security tab and then click Macro Security button

3) Select the "Trust access to Visual Basic Project" checkbox, or anything like it. Then OK

Next time you click the Excel Inplace icon on your report, it should work.

😃

Re: ALV EXCEL PROBLEM

Former Member — Fri, 18 Apr 2008 04:14:39 GMT

Hi,

Please check in the path tools->macro->security. If the Security level is high the data will not displayed in Excel in place from ALV. Recheck your Security Setting for displaying Excel in Place.

Now on the same path open tab -> Trusted Publishers and Check the checkbox for Trust Access to VB Project.

Pls reward if useful.

Thanks,

Sirisha.

Re: ALV EXCEL PROBLEM

Former Member — Fri, 18 Apr 2008 05:07:44 GMT

Thanks.

thanks&regards

sitaram

Re: ALV EXCEL PROBLEM

Former Member — Fri, 18 Apr 2008 05:08:45 GMT

problem solved

Thanks.

thanks&regards

sitaram