Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Excel not opening from Access Point

On one user's PC, when using AccessPoint and the Java client, when she clicks on the Excel button on any chart or table, Excel does not open.

When she clicks on the Excel button a 2nd IE window opens briefly and then closes again.

Excel used normally on her PC is fine. Other users can use Excel from AccessPoint fine.

Does anyone have any ideas why this would be happening?

All advice greatly appreciated.

1 Solution

Accepted Solutions
Not applicable

Excel not opening from Access Point

It actually turned out to be quite simple.
In IE, there are various security settings against each security zone. One of them is something like "Always prompt for file download". This needs to be enabled.
So what I did was add our QlikView AccessPoint URL to the Trusted Sites zone (so that I could be sure of which zone to edit) and then enabled that option in that zone.
It worked a treat and I've done it on 2 machines now.

7 Replies
Not applicable

Excel not opening from Access Point

hello
I'm having the same problem. You managed to solve it??

Not applicable

Excel not opening from Access Point

Hi

As far as I know sending to excel works only in IE plugin

Regards

Sravan

Not applicable

Excel not opening from Access Point

It actually turned out to be quite simple.
In IE, there are various security settings against each security zone. One of them is something like "Always prompt for file download". This needs to be enabled.
So what I did was add our QlikView AccessPoint URL to the Trusted Sites zone (so that I could be sure of which zone to edit) and then enabled that option in that zone.
It worked a treat and I've done it on 2 machines now.

Not applicable

Excel not opening from Access Point


sravan wrote:
Hi
As far as I know sending to excel works only in IE plugin
Regards
Sravan<div></div>


this is not true. it works fine with java and ajax

Not applicable

Excel not opening from Access Point

Wonder, this was it.
Thank you for the solution and agility in responding.

Not applicable

Excel not opening from Access Point

Hi Andrew,

I did not know that it works with Ajax and Java.

Did you get the same problem as in figure when you clicked on transfer to the excel sheet in the application?

Thanks in advance

Sravan

richard_chilvers
Not applicable

Excel not opening from Access Point

Hi

I have seen a similar problem. Although, if Excel is already open, the download works fine.

I am new to the QV server edition - is anyone able to explain "security zone" in the context of the reply above about security settings ?

Thanks.

Richard