topic Re: NPrinting Designer cannot find template editor - Office 365 in Qlik NPrinting

NPrinting Designer cannot find template editor - Office 365

Greg1291 — Wed, 06 Oct 2021 07:06:19 GMT

Hello,

me and my colleagues use NPrinting Designer locally with Office 365.

Yesterday, suddenly, we were not able anymore to open the NPrinting Designer when editing Excel reports.

We work for different customers with different versions of NPrinting and none of us is able to open the designer anymore.

Everything works fine with Pixel Perfect, Word and Power Point.

Do you know if there has been some kind of update to Excel 365? We started to experience this issue only yesterday and worked correctly for the last months.

I attach the error's screenshot

We already tried to solve the problem editing the screen resolution and the Designer.exe compatibility tab as explained here.

Thread 1

Thread 2

Thread 3

Thank you very much,

Davide

Re: NPrinting Designer cannot find template editor - Office 365

Ruggero_Piccoli — Wed, 06 Oct 2021 08:01:49 GMT

Hi,

This error message usually appears when you are using a not supported version of Microsoft Office or if it has installation issues. Supported versions are listed in https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/Installing-qlikview-nprinting-designer.htm

I suggest you to:

- check that your version of Office is supported

- if it is, try to uninstall and reinstall it

PixelPerfect and HTML templates have autonomous editors so they do not need to use Office.

Best Regards,

Ruggero

Re: NPrinting Designer cannot find template editor - Office 365

Lech_Miszkiewicz — Wed, 06 Oct 2021 08:03:15 GMT

Hi @Greg1291 ,

Are you running supported configuration according to help document on https://help.qlik.com?

https://help.qlik.com/en-US/nprinting/June2020/Content/NPrinting/DeployingQVNprinting/System-requirements_designer.htm

If you do and you reinstalled both Qlik NPrinting desgner and MsOffice then I think next step is support.

@Ruggero_Piccoli - do you think this is case for support?

cheers

Re: NPrinting Designer cannot find template editor - Office 365

Greg1291 — Wed, 06 Oct 2021 08:12:05 GMT

Hello @Ruggero_Piccoli and @Lech_Miszkiewicz ,

thanks for your reply!

The strange thing is that until yesterday everything worked fine and then Excel (and only Excel) began to behave in this way.

I already tried uninstalling and reinstalling NP Designer and Office without success.

I tried using a different version of Office (I have a personal account which is not 365) and it works properly but we use as agency Office 365 so that is not a proper solution.

I am trying right now to revert Excel to a previous version and I let you know what happened.

If this solution won't work I will open a case to support.

Thanks for your advice,

Davide

Re: NPrinting Designer cannot find template editor - Office 365

Ruggero_Piccoli — Wed, 06 Oct 2021 08:32:20 GMT

Hi,

"Qlik NPrinting Designer is not compatible with Microsoft Office 365 web or mobile. It is compatible with Microsoft Office 365 desktop." so be sure your installation was not moved to Office 365 web.

Best Regards,

Ruggero

Re: NPrinting Designer cannot find template editor - Office 365

Ruggero_Piccoli — Wed, 06 Oct 2021 08:35:18 GMT

@Lech_Miszkiewicz no, support team will ask the same if the installed version is supported or not. The fact that using the personal not 365 account is working means that the other used version is one of the not supported. Maybe 365 web edition.

Re: NPrinting Designer cannot find template editor - Office 365

Lech_Miszkiewicz — Wed, 06 Oct 2021 08:39:20 GMT

Well that is why i pointed out to check that all requirements are met including having office 365 Desktop installed which is listed there

Re: NPrinting Designer cannot find template editor - Office 365

Greg1291 — Wed, 06 Oct 2021 08:56:36 GMT

Hello @Ruggero_Piccoli ,

we checked and we are using Office 365 Desktop.

I tried reverting office installation (Excel v2108) and now everything works fine.

There is some kind of issue with Excel v2109. Do you think I should open a case to understand what the problem is?

Thanks,

Davide

Re: NPrinting Designer cannot find template editor - Office 365

Lech_Miszkiewicz — Wed, 06 Oct 2021 09:15:50 GMT

Hi @Greg1291

@Ruggero_Piccoli will probably answer that question better, however first thing support would ask you to do I guess would be to upgrade to NP May 2021 SR2 to be on the latest version, therefore the version which should have most of possible bugs resolved.

In your scenario it is clearly something wrong with the excel (meaning that this version of Excel does not work with that version of NPrinting you are running on).

At the same time I upgraded to Excel v2109 and with NPrinting May 2021 SR2 it works just fine after setting this in excel:

Re: NPrinting Designer cannot find template editor - Office 365

Ruggero_Piccoli — Wed, 06 Oct 2021 09:38:14 GMT

Hi,

I just checked and I'm using v2102 and I cannot update my installation to test v2109.

Yes, if you suspect that v2109 is causing the issue and v2108 is working you could open a support ticket for deeper investigation. At the moment we don't know any issue in using v2109.

I agree with @Lech_Miszkiewicz 's suggestion to upgrade to latest version, May 2021 SR2, to benefit of all solved bugs and test with it. Also because, if the testing will reveal an issue, it will be solved in future releases.

Best Regards,

Ruggero

Re: NPrinting Designer cannot find template editor - Office 365

Greg1291 — Wed, 06 Oct 2021 09:37:42 GMT

Thanks to both of you for the support!

Davide

Re: NPrinting Designer cannot find template editor - Office 365

Lech_Miszkiewicz — Wed, 06 Oct 2021 09:51:17 GMT

Having it set to "Optimize for compatibility" was causing the same error for me as @Greg1291 had.

I had similar errors in previous instalations too though and I guess update of Excel just resets that setting to default (maybe)?

So to replicate steps which cause error you just need to set it up to the setting as on gif below:

cheers

Lech

Re: NPrinting Designer cannot find template editor - Office 365

Digvijay_Singh — Wed, 06 Oct 2021 12:00:43 GMT

I also faced one different problem in powerpoint template, that was introduced in office 365 version 2102.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-Designer-clicking-on-close-button-X-throwing-error-Ver/m-p/1831781#M33150

Qlik support accepted at as a bug, last week we got response that it is planned to be fixed in May 2021 SP 3 but release date is not yet known.

In brief, its quite possible that something works in old office version and fails in new version.

Thanks,

Re: NPrinting Designer cannot find template editor - Office 365

Andrea_Bertazzo — Wed, 06 Oct 2021 14:38:01 GMT

This issue is currently under NPrinting Developers review (QB-7433). Please, contact Qlik Support in case the solution suggested by Lech_Miszkiewicz does not work. Please, specify what version of Office is in use and what is the latest Windows update in your OS.

Re: NPrinting Designer cannot find template editor - Office 365

Ruggero_Piccoli — Wed, 06 Oct 2021 14:58:34 GMT

Hi @Greg1291 ,

Please let us know the exact version of Excel that caused the issue. You can access it selecting File, then Account and opening the About Excel dialog.

Thanks.

Best Regards,

Ruggero

Re: NPrinting Designer cannot find template editor - Office 365

Greg1291 — Wed, 06 Oct 2021 16:58:36 GMT

Hello @Ruggero_Piccoli , here it is:

Regards,

Davide

Re: NPrinting Designer cannot find template editor - Office 365

Frank_S — Wed, 06 Oct 2021 17:26:54 GMT

Thank you @Greg1291

Your post information has been forwarded to R&D.

Keep in mind R&D is in Europe so unfortunately we may not get a response until tomorrow.

Re: NPrinting Designer cannot find template editor - Office 365

Frank_S — Thu, 07 Oct 2021 20:12:21 GMT

Hi @Greg1291

Please see this article about the issue and for a possible solution

https://community.qlik.com/t5/Knowledge/Qlik-NPrinting-can-t-find-supported-reporting-template-editor/ta-p/1716228