Excel Pop up issue in some reports

[Former Member]

Hi all,

We have some reports when run, the report pops up in excel. Now the issue, few of our users when execute in their system they r not getting the report pop up in excel. However, if they log in to my system using their user ID, the excel pops. I am also able to do so in my system with my user ID.

Does anyone know if there is setting which needs to be turned on/off in SAP or excel. The macro setting of mine and user is set to low in the excel.

Thanks,

JR

[danny_roussel4]

I have the same problem: it comes with the new gui installation GUI770Installation_6-70004682

I didn't have this before with the older GUI version

[danny_roussel4]

I mean GUI release 800 64bit

[former_member797945]

Hi,

If you using Excel 2010 or higher version, then you should open excel then open the below path

File-> Options->General - User Interface options. Select second radio button "Optimize for compatibility".

I have tested in GUI 760.

Regards,

Anil Gouda

[Amit91]

Thanks for the suggestion. I am using FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' to upload the file and was getting the same error.

[former_member352737]

Thanks for the sharing. It works.

[VISHAL_JHA]

Is it resolved ? despite changing the setting, The excel is getting opened. please suggest the solution.

Thanks

[akggouda91175]

Yes, it will work. Please close all your excel and start again.

Thanks,

Anil Gouda

[FreddyTorresC]

Nice post thanks Anil

[former_member188826]

It is very much in SAP on the report output setting. Aditionally, you could check the settings for office integration from the menu.

[Former Member]

Thanks for you reply.

But i dont see any environment tab or options tab where i can check office integration. Are there any other setting if anyone is aware of

Thanks,

JR

[Former Member]

Hi

Under office integration select Microsoft Excel.

If this is not what you were referring to do give more details along with the transaction code for the report.

Rgds

NW

[Former Member]

Apologize if my question is not clear.

We have an abap report in which I enter the selection criterea, the report will pop in excel. No SAP screen in output. Excel will pop up with the selection criterea entered.

1) I executre report in my system and I get the excel output.

2) User executes the same report in his system and does not get the output

3) User executes the same report in my system using his user ID and the report pops up.

In the ABAP report, there is no option to select Office Intergration.

Now, there is something different in my system and user system. Does anyone know what can it be so that when user execute report in his systme, he gets the excel output.

Thanks

JR

[former_member188826]

Check the excel version in the user's computer. Which release are you in, both sap and excel. This may be something to do with xl more than SAP?

[Former Member]

Hi

Also check the security.

Open any excel sheet in the user's PC and go to Tools > Macro > Security.

Ensure :

1) Security level tab - is set to Medium or Low and

2) Trusted Publishers tab - "Trust all installed add-inns and templates" is ticked/selected.

Nadini