cancel
Showing results for 
Search instead for 
Did you mean: 

Entry and Approval - Download Data to Excel

bruno_heissler2
Participant
0 Kudos

Hi Guys,

I´m putting data in Entry and Approval Interface and in a particular Metric I would like to download the Actual/Target informations to Excel.

When I clicked in "Dowload Excel", I got a prompt error information:

"Error Opening Excel. This can be caused by:

1 - Application is not installed in your machine

2 - Browser security dos not allow ActiveX scripts

3 - You were prompted to run ActiveX and you said No

If that is the case close all browser instances and reopen."

I´ve already fixed the ActiveX settings into IE Browser. I accessed the ActiveX settings and Enable all the prompts, accordin the SSM Configuration Guide.

I downloaded and Installed the Front End - Excel Add In in my client machine. I also installed this component into the server SSM machine.

What should be missing in my environment? Should I configure some additional steps before installed the Excel Add In?

The Excel Add In component, is responsable to enable the "Dowload Excel" step?

Best Regards,

Bruno Heissler

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Bruno,

Goto tools -> Internet options -->Security, under the security tab, you can find the customlevel button.click on it.

you can find list of properties,go to Activex controls and Plugins-->Enable the option Initialize and script activex controls not marked as safe for scripting

Regards

Bala

bruno_heissler2
Participant
0 Kudos

Bala,

According my post above, I´ve already updated the ActiveX parameters under Internet Explorer Options. So, this not solved my issue.

I´m still getting the error massage when trying export SSM data for excel.

What should be?

Best Regards,

Bruno Heissler

Former Member
0 Kudos

Was this issue resolved?

bruno_heissler2
Participant
0 Kudos

Not yet.

Bruno Heissler

bruno_heissler2
Participant
0 Kudos

Guys,

I worked together Bala on this error.

Firts of all I was working with Office 2010. I removed it and installed Office 2003.

I followed all the steps from the "SSM Excel Add In Installation Guide".

I´m working with Internet Explorer 7.0.

The settings related to the Active X should be enable under the Security tab.

(I was enable just the Trusted Sites ActiveX settings and not Internet too. This was the problem)

After this changes, I could look for data from E&A Interface and Export some informations to Excel.

Best Regards,

Bruno Heissler

Former Member
0 Kudos

Hello friends

To give a contribution to the case, I can comment that we have certified that the LOAD of historical data and targets on SAP SSM10 SP8 (Entry and Approval option) works fine, with Microsoft Office Excel 2013. Only we will have to modify the Internet Explorer security to allow Active X, as indicated by SAP or other threads in this forum.

Regards

Ricardo.