QlikView - Export to Excel problem on IE-PlugIn - ActiveX can't create object "Excel.Application"

[aldo-tgh]

Hi guys,

Need some advice with the situation described below.

Thanks in advance,

Aldo.

We are using QlikView 11.20 SR7 on Windows 7.

Users connect to QV Server throw IE-PlugIn.

For most users, export to Excel works fine (left click and also throw macro), but we have some users that when trying to export, (left click), nothing happens and, If trying to export to Excel using macro, we get the following message "ActiveX can't create object "Excel.Application".

When trying to check macro settings "Ctrl+Shift+M", nothing happens.

If we try, on same user, same app, to export to excel in AJAX, it works fine.

On desktop works fine also (both of them, left click and throw macro).

We tried, on IE 9,10,11

Tried to remove and reinstall IE-PlugIn

We also reset IE settings.

Tried to repair Excel installation.

Tried with disable of "Protective View" in Excel.

[aveeeeeee7en · Accepted solution]

Hi Aldo

I have also faced the same issue in recent times.

But with the help of QlikTech I have fixed this Issue after doing some settings in Internet Explorer.

Follow these Steps:

1) Open Internet Explorer.

2) Go to Security Tab

3) There you see an Option Enable Proected Mode which is By Default Checked.

4) Uncheck this Option.

5) After doing this, Restart your Internet Explorer.

6) Now your Send to Excel command will work.

See the Snapshot:

Regards

Aviral Nag

[aldo-tgh]

That was the problem.

Thanks!

Aldo.

[micahsakata]

is there another work around to turning protected mode off?  my company's security policy will periodically overwrite this if i change it.  therefore this is not a good option.