SAP EXCEL is not opening

[Former Member]

Dear Experts,

When I Executive any Report in SAP via SE38.Then I want to open that Report in SAP Excel.Its give messege in bottam bar

View cannot be switched : Product is not installed or integration is not active.

Thanks

MANU

[Former Member · Accepted solution]

1. By any chance are you running SAP GUI on Citrix session ? Which means Excel must be installed on the Cirtix Server

2. While installing SAP GUI on the PC (if you are using SAP GUI on std PC), did you select check box where you have interagtion componets(EXCEL/ MS Office integration) and also have atleast GI patch 2 for GUI 710 ( or good to have current patch level 9 .

Hope this helps,

Krishna

[Former Member]

Hi,

Did you receive any resolution for this?

do let me know would really appreciate as we are facing the same problem.

Have already tried most of the steps mentioned in the thread.

Regards,

Amit.

[Former Member]

Amit,

Ask Basis team team to install GUI on the work station with ADD-ON's option, then only you will be able to see the excel view...

Hope this will resolve your problem.

[markus_doehr2]

- Excel version?

- SAPGUI version and patchlevel?

Markus

[Former Member]

Thnaks Dear Marks,

I am using ECC 6.0 .My SAP GUI 710

When I Excecute Program via SE 38 .Its a Z Program

Marks its a ALV REPORT of Purchase Order

But When open in direct Excel (Because Excel icon in Menu Bar)

In Task bar messege is comming

View cannot be switched: Product is not installed or inte gration is not active

Manu

[markus_doehr2]

Does it work with other transactions?

Markus

[Former Member]

Marks No . Its not working with other transastion.

Thanks

manu

[Former Member]

Hi,

Is Excel installed on the host ?

if yes which version of excel you are using?

if you are using office 2003 then do following

open office excel -> tools -> macro -> security

security level -> medium

trusted sources -> check trust access to visual basic project.

if you are using office 2007 then do following

Click on Office button -> Click excel options -> trust center -> trust center settings -> macro settings -> check Trust access to VBA project object model

regards,

kaushal

[Former Member]

Dear kaushal,

SAP Office not open

Mean when I Open with T-code coid

Order Header will be selected .Press Enter

Then Order Info system :Detail list report for Order Header will come . here we give

Profile -

---

Plant -

---

Sys. Status -

---

Then Executive F8

Report will come .

Now Export Icon in the Menu Bar then select Spreadsheet

One Pop Messege come

Save XXL List Object in SAP Office

Name of List object ALVXXL01

Title of SAP Office

Executive

I want to open this one in SAP Excel ( Direct open in SAP excel Format)

I thing u understand my problem

Thanks

Manu

[Former Member]

Hi,

First respond to my query.

Is Microsoft Excel installed on the host ?

if yes then which version of Microsoft office you use ? which OS you are using?

regards,

kaushal

[Former Member]

I am using windows XP & Office is MS 2003 standerd.

Thanks

manu

[Former Member]

HI,

When you try to open the list , ms excel is opened or you get some other message?

regards,

kaushal

[Former Member]

Manu,

This is because of below 2 reasons

1) MS excel macro security will be medium and select "Trust access to Visual Basic Project" in the Trsusted Sources Tab.

2) When Basis team install GUI on the work station, they should select the ADD-ON's option, then only you will be able to see the excel view....Looks like this is the one you dont have on your work station.

Let me know if you need more information.