Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone have a solution for NPrinting Sept 2018 onwards for how to default an excel pivot to have collapsed fields?
All the answers I have seen so far relate to options available in NP 16 for saving as xlsm and adding macros but removed from 17 on where these options are not available.
thanks,
Hi,
Here is an example: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/collapse-rows-in-excel-pivot-table-Nprintin...
HTH - Daniel.
Hi, the functionality to use .xlsm templates is back in the latest version of NPrinting 17 - Sept 18.
Chris
Agree with Chris - write macro.
regards
Lech
Hi,
Here is an example: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/collapse-rows-in-excel-pivot-table-Nprintin...
HTH - Daniel.
Many thanks - got there in the end.