The following error is displayed when opening the Qlik NPrinting Template Editor:
Qlik NPrinting can't find a supported template editor for the file .... the object reference is not defined as an instance of an object.
This error can be caused by a number of different root causes. We will be covering the most frequent issues and their solutions in this article.
Before proceeding to Root Causes and Solutions, please review the NPrinting Designer system requirements
Note: Are you having trouble repairing or uninstalling MS Office? Please see the attached help article from Microsoft: "Microsoft Support and Recovery Assistant"
Root Causes and Solutions
Root Cause: Qlik NPrinting Designer requirements are not met.
Solution:
Verify that your setup meets the system requirements. See System requirements for Qlik NPrinting Designer for details.
NOTE: Virtualized desktops where NPrinting is installed are not supported ie: Citrix deployments
NOTE: You must be using a locally installed copy of MS office. Web-based versions are not supported. See: Is Office 365 supported in Nprinting Designer, and are there any known issues or incompatibilities?
Root cause: Operating System Resolution settings and Desktop Settings
Your Operating System Advanced Scaling/r=Resolution settings are not set to 100 percent or other resolution-related settings need to be adjusted.
Solution
Review NPrinting Designer Preview Fails, Does not open or template editor problems and follow all the suggested solutions.
Root Cause: Outdated Qlik NPrinting Server, Engine, and Designer
Solution:
Verify that your Qlik NPrinting installation is up to date and that the Designer, Server, and Engine are all on the same version. Always keep your Qlik NPrinting setup up to date.
Root Cause: Microsoft Office is not correctly installed or not correctly associated.
Solution:
Verify that Microsoft Office can be opened on the machine running the Qlik NPrinting Designer. In case any Office extension is not associated with the right program, please, follow this article to fix the issue.
Root Cause: Microsoft Office and Windows Update
A Microsoft Office Update in 2021 has led to compatibility issues. These were resolved as per Qlik's Internal defect ID OP-95579.
See this article's appendix for additional details.
Solution:
The fix on Qlik's end was originally introduced in May 2021 SR3 (Release Notes). If you are on a version prior to this, upgrade to the latest version of Qlik NPrinting.
Root Cause: Faulty or corrupted installation of MS Office or Qlik NPrinting
Solution
- Repair the Microsoft Office Installation.
- Restart.
If this does not resolve the issue:
- Uninstall the Qlik NPrinting Designer
- Download the Qlik NPrinting Designer software version that matches the identical version of your Qlik NPrinting Server
- Uninstall Microsoft Office
- Restart
- Reinstall Microsoft Office and then NPrinting Designer
- Reboot
Root Cause: Incorrect Office registry keys
Solution
Follow this article.
Root Cause: Anti Virus software is interfering.
Solution
See Qlik NPrinting Server and Designer Anti Virus Folder Exclusions.
Root Cause: Unsupported setup
Solution
- Modify your setup to match the system requirements.
- Install a supported copy of Microsoft Office and license it.
- Install the NPrinting Designer.
Alternative Solution if the previous one does not work
- Complete removal of Microsoft Office & NPrinting designer
- USE THIS FOLLOWING STEP WITH CAUTION BEFORE PROCEEDING: once the removal is completed, delete and recreate the Windows user profile of the windows account (save all desktop files, document folder data, public folder data, and documents folder data before proceeding with this option.
- Once the new profile is created, install a supported version of MS Office and NP designer then reboot and retest.
NOTE: Deleting a windows user profile from your computer will result in the loss of all files and folders associated with this user profile deletion. Ensure to backup desktop profile files and folders before proceeding
Root Cause: Insufficient Account Privileges
The Qlik NPrinting Designer is installed with an account that has insufficient installation privileges.
Solution
See Dedicated NPrinting Service Account Configuration.
Root Cause: The Qlik NPrinting Designer is not installed on C:\ Drive
The Qlik NPrinting Designer must be installed on the C:\Drive
Solution
Reinstall Qlik NPrinting Designer on the c:\ drive
Root Cause: MS Office 32 bit versions
Use MS office 64 versions where possible
Solution
See : Qlik NPrinting cannot find a supported template editor with Error: Object reference not set to an i...
Appendix
NOTE Dec. 21, 2021:
- May 2021 SR 3 NPrinting is now available for download
- Please upgrade all NPrinting Components to resolve this issue including:
- NP Server, NP Designer and NP Engine (NP On Demand components if applicable to a QlikView environment).
- If the issue is not resolved by upgrading, please proceed to the section below "If this MS Office update problem is not your issue, then please proceed below"
- Release Notes May 2021 SR 3 (see defect ID OP-95579 - in Resolved Defects section): https://community.qlik.com/t5/Release-Notes/Qlik-NPrinting-May-2021-SR3/ta-p/1872634#toc-hId--164636...
- Recommend upgrading to the most recent version of NPrinting however to leverage all current fixes and updates
NOTE Oct. 7, 2021:
- This error is recently been caused specifically by an MS Excel version upgrade/windows update
- This issue has been found thus far in the following MS Excel builds
- version 2109 (Build 16.0.14430.20224) 64 bit
- version 2109 (Build 16.0.14430.20270)
- Current workaround is to
- Repair: Perform a full MS Office Online Repair operation or...
- Roll Back to your previous version of MS office
- If using Office 20219 v2109 perform the steps in the following article:
- A fix for this MS Office update issue is implemented in May 2021 SR 3 NPrinting
- For latest updates visit:
