topic Re: ACTIVEX Excel in Qlik NPrinting

ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 08:01:03 GMT

Hello Community

Version Designer 21.0.2

Version Server 21 . 0 .2 SR1

I have an issue about nprinting with Excel ActiveX

NPrinting Designer has ActiveX COM error - Qlik Community - 1800671

-already modify designer exe with the compatibilty tab "run as administrator'

-Stop and restart all the nprinting services

-Already uninstall/install office 2016

But it's always on error

for your info Powerpoint/Word ==>Ok Excel =>OK

Alexandre

Re: ACTIVEX Excel

Lech_Miszkiewicz — Wed, 08 Sep 2021 08:06:57 GMT

NPrinting designer requires "Zoom Level" to be set to 100% on all your screens - do you meet this requirement?

Re: ACTIVEX Excel

Lech_Miszkiewicz — Wed, 08 Sep 2021 08:08:22 GMT

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-template-editor-excel-zoomed-in/td-p/1571948

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 08:10:41 GMT

Hello

i dont understand your post.

may can you explain to me by an other way?

Alexandre

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 08:13:26 GMT

Ok it is not the same issue

Nprinting cannot edit the Excel template, i have an issue

Re: ACTIVEX Excel

Lech_Miszkiewicz — Wed, 08 Sep 2021 08:15:37 GMT

On the PC where you have designer installed go to:

Settings
- Display
  - Scale and layout and set it to 100% for all screens (if you use multiple screens)

Re: ACTIVEX Excel

Lech_Miszkiewicz — Wed, 08 Sep 2021 08:28:34 GMT

1. Well, the error you are showing can be thrown if you dont meet 100% zoom requirement. So first thing is to confirm that you have 100% zoom level set.

Setting it to 100% obviously requires you to log off and log back on as not all settings can be applied.

Once we confirm that you have 100% zoom level configured and you still have issues then we will move on and try another things...

2. Make sure your Excel can run, is licensed and is in "Optimize for compatibility" mode

3. On another note - do you have any Add-Ins installed in your Excel? If this is corporate PC sometimes companies install add-ins which may prevent it from running properly

cheers

Lech

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 09:04:05 GMT

i cannot change the zoom on settings/display (because of remote session)

Dont understand the zoom 100% with my issue ActiveX ...

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 09:06:23 GMT

it is ok with powerpoint or Word but not with Excel

Re: ACTIVEX Excel

Lech_Miszkiewicz — Wed, 08 Sep 2021 11:09:31 GMT

ok - if its RDP that is different story with the zoom level... I guess you are trying to run it on the server... What about other points I mentioned (excel activation, add-ins etc)?

@Ruggero_Piccoli - do you have anything to add to this?

thanks

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 11:52:52 GMT

Hello , this is all the steps i made

-already modify designer exe with the compatibilty tab "run as administrator'

-Stop and restart all the nprinting services

-Already uninstall/install office 2016

-cannot change the zoom level

About the Add in , should i delete the add in in excel?

Re: ACTIVEX Excel

ALEX1977ALEX — Wed, 08 Sep 2021 13:25:47 GMT

There is no active add in! =>always the same issue

My customer don't understand what's going on.

Word and Powerpoint template ==>OK

Excel template ==>KO

Re: ACTIVEX Excel

Frank_S — Wed, 08 Sep 2021 13:51:43 GMT

Alex,

RDP session will take the settings of your desktop computer that you are accessing the remote server with. This mean you would need to update your desktop settings (and all attached monitors) to 100 percent....then reboot your computer and retest.

https://community.qlik.com/t5/Knowledge/NPrinting-Designer-does-not-open-preview-Fails-or-other-template/ta-p/1782144

If this doesn't work please start a support request.

Kind regards...

Re: ACTIVEX Excel

Ruggero_Piccoli — Thu, 09 Sep 2021 10:53:12 GMT

Hi,

The error is "can't find a supported template editor" so I suppose you are using an unsupported version of Microsoft Office or you have issues in its installation. Supported versions are listed in https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/System-requirements_designer.htm

You can also try to uninstall and reinstall Office.

I used the Designer via RDP many times without issues but we suggest to avoid to use it on the Server to avoid restarts due to the Designer.

Best Regards,

Ruggero

Re: ACTIVEX Excel

ALEX1977ALEX — Thu, 09 Sep 2021 11:48:31 GMT

Hello Ruggero

I have already uninstall/install Office 2016

In fact powerpoint and word are ok with nprinting , but only with excel it ' s failed.

I need to wait my admin in order to configure the 100% zoom in the display setting for excel but it seems very bizarre

May can we make a meeting in order to show you where is the problem?

Re: ACTIVEX Excel

Ruggero_Piccoli — Thu, 09 Sep 2021 12:27:14 GMT

Hi,

To organize a meeting please open a support ticket with the link to this conversation. A support team member will answer you.

Best Regards,

Ruggero

Re: ACTIVEX Excel

marcus_sommer — Thu, 09 Sep 2021 13:08:08 GMT

Before looking for any errors within NPrinting or Office and re-installing it again and again makes sure that the mentioned folder/files exists and your user has access to. Further take a look if (all features) of ActiveX are enabled on the machine and for your user. Especially on servers it's not seldom that not everything is installed, activated and then enabled for all users.

- Marcus

Re: ACTIVEX Excel

ALEX1977ALEX — Mon, 13 Sep 2021 12:38:48 GMT

Hello Marcus

My IT TEAM cannot change the displaying/settings up to 100% they are on remote mode too

so we have always this issue

About Activex on Excel , i made some verification but can i have some link in order to check if it is ok

Cheers Alexandre

Re: ACTIVEX Excel

marcus_sommer — Mon, 13 Sep 2021 13:00:24 GMT

I'm not an expert to this matter and therefore I couldn't provide any detailed hints. Just struggled once or twice for many years with such stuff and solved my issues with some researches on google and some trial & error. It's definitely not a nice job - I hope you have some experienced guys within your team.

- Marcus

Re: ACTIVEX Excel

Maria_Halley — Tue, 14 Sep 2021 06:55:39 GMT

@ALEX1977ALEX

It might seem bizarre to change the resolution as a fix, but it is what fixes this in most cases.

Not sure if this shared already.

https://community.qlik.com/t5/Knowledge/NPrinting-Designer-does-not-open-preview-Fails-or-other-template/ta-p/1782144

Kind regards,

Maria Halley