Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

aldo-tgh
New Contributor III

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

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.

Tags (2)
Labels (2)
1 Solution

Accepted Solutions
aveeeeeee7en
Valued Contributor III

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

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:

windows-7-security-ie8-protected-mode-settings Uncheck Conditions.PNG.png

Regards

Aviral Nag

12 Replies

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

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
New Contributor III

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

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.

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

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
New Contributor III

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

I am checking the ini file.

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

Thanks,

Aldo.

aldo-tgh
New Contributor III

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

Marcus,

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

Where should I find the ini?

Thanks,

Aldo.

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

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
Contributor III

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

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

Capture.JPG.jpg

Marty.

gno
Valued Contributor II

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

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

Not applicable

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

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.