Excel Pivot tables - collapsed rows

[stig1984]

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,

[chriswain2]

Hi, the functionality to use .xlsm templates is back in the latest version of NPrinting 17 - Sept 18.

Chris

[Lech_Miszkiewicz]

Agree with Chris - write macro.

regards

Lech

[Daniel_Jenkins · Accepted solution]

Hi,

Here is an example: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/collapse-rows-in-excel-pivot-table-Nprintin...

HTH - Daniel.

[stig1984]

Many thanks - got there in the end.