Problem in changing layout of ALV to excel

181 Views

Hello everyone,

I have developed an ALV program, wherein I need to show the graphs for the same.

For this, I need my data in excel format, so that I can write some macros ,and do the further processing on it(I am using an appraoch I found on SDN, "Report with graph").

I got to know, that I need <b>SAP R/3: Add On:Interactive Excel</b>.

I asked the BASIS guys to install it, but even after installing it, I am unable to view the data in Excel layout, when I do Change LAyout->View->Microsoft Excel.

Could anyone let me know if there is any other setting which is required to view the data in excel?On the excel side, we can change the security level(Tools->Macro->Security) to either low, medium or high.

Is there any such provision in SAP?

Kindly suggest your answers, as it is important for me to get the data in excel.

Points will be rewarded.

Thanks and regards,

Prerna