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
Showing results for 
Search instead for 
Did you mean: 

ALV View does not transfer body info to Excel View.

Former Member
0 Kudos

Hi All,

I created a ALV Grid display for a report.

When I click on the view change for Excel, only the header data is visible.

The body of the report does not get transfered to excel view.

I have another user that is able to do this procedure with succes for the same report.

I had Basis Team trace the transaction and there's no authorisation problem for the user.

I looked to make sure that I have the excel templates.

And I do have sap_om.xls and sap_mm.xls installed.

Does anybody have any idea of what I am missing to be able to display in Excel view?

Best Regards!

Curtis

1 ACCEPTED SOLUTION

Clemenss
Active Contributor
0 Kudos

Hi Curtis,

in excel, you must Trust access to the VBA project object model

Regards,

Clemens

3 REPLIES 3

Clemenss
Active Contributor
0 Kudos

Hi Curtis,

in excel, you must Trust access to the VBA project object model

Regards,

Clemens

Former Member
0 Kudos

Hi Clemens,

I am using Windows XP with Excel 2003.

I cannot find the trust center for excel......

Lookup in google and seams to be for 2007.

Regards!

Curtis

Former Member
0 Kudos

Hi Clemens,

I anwered a bit to fast.

You are correct. I found the option in excel2003 and all works fine.

Thank you!

Curtis