Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
stig1984
Creator II
Creator II

Excel Pivot tables - collapsed rows

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,

1 Solution
4 Replies
chriswain2
Creator
Creator

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

Chris

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Agree with Chris - write macro.

regards

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.
stig1984
Creator II
Creator II
Author

Many thanks - got there in the end.