Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

REUSE_ALV_GRID_DISPLAY for Excel display

Former Member

‎10-09-2007 3:14 AM

0 Kudos

Hi Experts,

I am using FM 'REUSE_ALV_GRID_DISPLAY' for ALV reports. In my system I am using Excel 97 version and I could see the output in excel format when I press Microsoft Excel (ctrlShiftF7). But my user is using version 2003. He couldn't see the data but only empty sheet.

How can I solve this..?

Regds,

Vinsa.R

2 REPLIES 2

Former Member

‎10-09-2007 3:17 AM

0 Kudos

Hi Vinsa,

I don't think there should be some problem because of Excel version. May be basis require some settings to be done. Have you checked with some more users the same thing.

Also search OSS, you may find something there.

Regards,

Atish

Former Member

‎10-09-2007 6:21 AM

0 Kudos

The problem is with the Security settings of the Excel macro.

Go via this Menu in Excel - Tools>>Macro>>Security.

In your system it might be medium or low. But I guess ur client has set it to High or very high.

With this security setting the ALV_GRID wont be able to call the Excel functions for passing the data ranges. Ask him to change it to Medium and ur grid display will be able to show u the data.