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.

[marcus_sommer]

I think this is a security issue related to the user-profiles which allow or didn't allow ActiveX. Also have a look on the settings.ini - I'm not sure if a new-installation would be create a new one - if a user has refused the macro-execution and enabled the option "didn't ask again" he could never more use a macro. In this case remove the settings.ini (Backup it before).

- Marcus

[aldo-tgh]

Hi Marcus,

Thanks for your answer.

Two questions:

1.- Where do I find the ini file?

2.- Export to Excel by Left Click (no macro) doesn't work either...

Aldo.

[marcus_sommer]

You will find the settings.ini here: C:\Users\YourUser\AppData\Roaming\QlikTech\QlikView.

It's difficult to say which could be the reason there are many possiblities to cause that. Have your users tried it with pc's from colleagues which could export and conversely?

- Marcus

[aldo-tgh]

I am checking the ini file.

All other users can successfully export to Excel using both macro and left click.

Thanks,

Aldo.

[aldo-tgh]

Marcus,

There is not QV desktop installation in the machine, just Plug-In.

Where should I find the ini?

Thanks,

Aldo.

[marcus_sommer]

This is the standard-folder for the IE-Plugin settings.ini. If there no settings.ini an other folder was used while the installation, the installations isn't complete/correct or the settings are written within the registry (but afaik this was only used in the earlier versions from qv).

- Marcus

[martynlloyd]

You mention a macro so check your Module security and change to System Access:

Marty.

[Giuseppe_Novello]

Aldo,

Since the Macros need to get to your excel, it needs system access, for that from "Requested mode Security = SAFE MODE" switch it to " System Access" . ( Below post of Martyn has the image I am talking about.)

Martyn- I just putting little more explaination for Aldo to understand, not coping you thoughts 😉

Gio

[#10]

Last time I saw this, it was because the server installation was a release behind.   You may want to double check that you upgraded the latest version of the server... not just the developer version on the workstation.