Collapse in Pivot table Nprinting?

[Anonymous]

I have created excel report in Nprinting. I need always collapse but am unable to do . it is always expanded how can i collapse?

[Daniel_Jenkins · Accepted solution]

Hi Lakshmi,

You will need to use XLSM format and write VBA code in the Workbook_Open event.

See: Re: collapse rows in excel pivot table - Nprinting

HTH - Daniel.

[Anonymous]

Hi thanks for your replay. I tried but it is not working.  I saved file as  "excel macro _enabled workbook" after reload task it is not collapsing.