topic Re: Export to Excel differences in Application Development and Automation Discussions

Export to Excel differences

Former Member — Tue, 20 Apr 2010 17:26:06 GMT

Right now, when I export a report to Excel (List -> Export -> Spreadsheet), the report will come out in Excel looking exactly as it did in SAP.

I have a user who is trying to run the same report, same transaction, same everything. However, when their report comes out in Excel, it looks extremely different, with columns in different places and other miscellaneous changes. This is strange because their process to export the report to Excel is the same as mine. They are doing everything as I am, yet they recieve a different result.

The only difference between our 2 users is our security roles. I have have nearly all SAP roles while this user does not have very many (our company uses custom roles).

What authorization object (or generic user role) am I looking for that would allow a report to be exported to Excel correctly? What do you think this user could be missing that my user currently has?

Re: Export to Excel differences

Former Member — Tue, 20 Apr 2010 21:32:46 GMT

Hi,

In the Client system, Please try doing the below changes in the excel.

Tools->macros->security, in the Trusted Source tab Check both the Check boxes.

Regards,

Naveen,

Re: Export to Excel differences

Former Member — Wed, 21 Apr 2010 11:13:19 GMT

Can you elaborate on where I can find this? I cannot seem to find my way to this particular transaction.

Re: Export to Excel differences

Former Member — Wed, 21 Apr 2010 13:02:06 GMT

Cameron,

I think what Naveen is saying is that you need to check / change these options in Excel ... not in SAP. On my computer (Excel 2003) the menu path provided by Naveen works fine.

Hope this helps ...

Duane

Re: Export to Excel differences

Former Member — Thu, 22 Apr 2010 13:23:25 GMT

Hi Camron,

Just open any an excel file even new one, after excel opened find the Tools and click it at menu bar, Then find options at drop down menu and click it, find security option card click it, find Macro Security.

Now operate according to Naveen told you.