03-30-2008 11:11 AM
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
04-18-2008 5:01 AM
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.
😃
03-30-2008 11:51 AM
Hi,
WHEN U CLICK EXCEL BUTTON THE DATA GETS DOWNLOADED INTO EXCEL FILE
Regards,
V.Balaji
Reward if Usefull...
03-30-2008 12:24 PM
03-30-2008 1:01 PM
hi,
As an alternative, do the following.
Goto
List --> Save --> excel --> give a filename.xls
I guess this will help you otherwise.
Thanks,
VV
03-30-2008 1:14 PM
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
03-30-2008 1:21 PM
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,
VV
04-18-2008 5:01 AM
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.
😃
04-18-2008 6:07 AM
04-18-2008 5:14 AM
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.
04-18-2008 6:08 AM