topic Export to Excel not working in QlikView

Export to Excel not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a few QlikView users that when they click on the XL icon to export to Excel, nothing happens or Excel opens up and the page is blank. Any idea how to fix this issue? Thanks.

Re: Export to Excel not working

Anil_Babu_Samineni — Fri, 14 Jul 2017 16:37:02 GMT

Do you write any macro to achieve this?

Re: Export to Excel not working

Anonymous — Fri, 14 Jul 2017 17:48:11 GMT

No I do not. I just have the box checked under the Chart Properties on the Caption tab that says Send to Excel.

Re: Export to Excel not working

antoniotiman — Fri, 14 Jul 2017 18:55:28 GMT

Check this in QMC -> Documents

Re: Export to Excel not working

Anonymous — Fri, 14 Jul 2017 19:03:05 GMT

This box is already checked. Could it be an issue with the users computer that is causing the reports not to export?

Re: Export to Excel not working

Muthu — Mon, 17 Jul 2017 05:12:47 GMT

Try to select only limited data and click on export.

May be if data is huge this problem occurs.

Re: Export to Excel not working

Anonymous — Tue, 18 Jul 2017 18:05:57 GMT

I selected 2 lines of data and it still did not work. Excel opens but the page is blank and no sheet opens up. See image below.

Re: Export to Excel not working

trdandamudi — Tue, 18 Jul 2017 19:20:18 GMT

Did you tried this on couple of PCs ? Is this happening only on a particular PC ?

Re: Export to Excel not working

Anonymous — Tue, 18 Jul 2017 19:24:19 GMT

It is only happening on a couple of PC's. If I log in using the same user account and export it to Excel on my machine or several other coworkers machines it exports fine. I feel like the issue is PC/Excel related but I don't know how to fix it. Thanks.

Re: Export to Excel not working

trdandamudi — Tue, 18 Jul 2017 19:28:03 GMT

ok got it. Are you using Excel 2016 ? If you are, then did you upgraded recently ?

Re: Export to Excel not working

Anonymous — Wed, 19 Jul 2017 14:47:43 GMT

No, we are currently using Excel 2013 and have not upgraded recently.

Re: Export to Excel not working

trdandamudi — Wed, 19 Jul 2017 16:54:22 GMT

Ok. It looks like it is an issue with the MS office. My guess is, If you re-install MS Office it will work. Other than that I don't think there is any other solution.

Re: Export to Excel not working

Anonymous — Thu, 20 Jul 2017 16:07:49 GMT

We have un-installed and re-installed MS Office and it did not correct the issue. If anyone has any ideas what this could be I would appreciate it. Thanks.

Re: Export to Excel not working

Anonymous — Thu, 20 Jul 2017 17:43:31 GMT

Un-installing and re-installing MS Office actually ended up correcting the issue along with one additional step. We had to add our URL to the trusted sites in IE.

Below is how you add it to a trusted site.

Open IE.

Click on the Settings icon.

Click on Internet options

Click on the Security tab and then click on the Sites button.

Click on Advanced.

Make sure that your Qlik URL is in the list and if it is not, add it.

Re: Export to Excel not working

jamshed07 — Wed, 14 Apr 2021 13:17:31 GMT

Yes we are using Ms Excel 2016, what is the issue? Could you please explain the solution