Excel problem

[Former Member]

When I click on Microsoft Excel in ALV report output, its opening excel sheet within SAP without any data. I have checked the code and there seems to no issues with code. Can someone help with any info for resolving this issue?

Moderator message: please use a more meaningful subject line next time.

Edited by: Thomas Zloch on Mar 24, 2010 4:19 PM

[Former Member]

Hi Sandipan,

I have faced similar issue in past. The problem is not with code, but with macro settings of excel. For MS 2007 version, here is the solution:

Go to

Macro security -> Macro Settings -> Developer Macro settings

Ensure that the box u2018Trust access to Visual Basic Projectu2019 is checked;

Click OK.

Exit Excel.

Let me know if this helps.

Regards,

Shiva

[Former Member]

In your ALV toolbar (GUI Status), change the Excel function to &XXL. If in SALV, copy SALV_STANDARD GUI from one of the SALV_DEMO* programs, add &XXL to the tool bar and set your regular Excel method to abap_false. Call the GUI_STATUS in your SALV set up after the factory, before the alv->display( ).

See my other reply for this problem.

[Former Member]

I have faced same problem in SAP Version 4.7.

Solution 1:-

Macro security -> Macro Settings -> Developer Macro settings

Ensure that the box u2018Trust access to Visual Basic Projectu2019 is checked;

Click OK.

Exit Excel.

After Implementing Solution1 --> still u r facing same problem it is sap gui issue

Solution2: if your using SAP 4.7, and h Windows vista with Service pack2 this is related to SAP GUI problem

Please install SAP latest GUI version Patch level 16 this issue will resolve automatically.

Thaks & Regards

Sudheer Madisetty