Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
chriswain2
Contributor

NPrinting 17 Macro Enabled Excel Templates

Hi,

I am finding the lack of macros in Excel templates in NPrinting 17 a real problem.

In version 16, you could output some data into an Excel sheet and have a macro execute on opening to change a named range and refresh all pivot tables to give well formatted summary reports with the ability to drill to details. Without it, you would have to tell recipients to change pivot table ranges and refresh - messy, some would need training and there is a danger that they would look at the unrefreshed pivot tables and think that was the latest report, so not very practical.

All NPrinting has to do is ignore the macros in the Excel document, so could this be a priority in the next upgrade?

Regards,


Chris

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: NPrinting 17 Macro Enabled Excel Templates

This is already available in the September 2018 release. You can read the release notes here.

Excel reports generated in .xlsm format

Qlik NPrinting can generate Excel reports in .xlsm format. Visual basic macros can be created inside the Qlik NPrinting Designer and will be available in the final report. However, they are not executed.

View solution in original post

3 Replies
Partner
Partner

Re: NPrinting 17 Macro Enabled Excel Templates

This is already available in the September 2018 release. You can read the release notes here.

Excel reports generated in .xlsm format

Qlik NPrinting can generate Excel reports in .xlsm format. Visual basic macros can be created inside the Qlik NPrinting Designer and will be available in the final report. However, they are not executed.

View solution in original post

Re: NPrinting 17 Macro Enabled Excel Templates

Agree with Alex!

Also refer to https://help.qlik.com for feature refereneces of all available software versions.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
chriswain2
Contributor

Re: NPrinting 17 Macro Enabled Excel Templates

That's great news, thanks!