Export to Excel differences

[Former Member]

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?

[Former Member]

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,

[Former Member]

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

[Former Member]

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

[Former Member]

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.