topic Re: Collapse in Pivot table Nprinting? in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161201#M11632 <HTML><HEAD></HEAD><BODY><P>Hi Lakshmi,</P><P></P><P>You will need to use XLSM format and write VBA code in the <EM>Workbook_Open</EM> event.</P><P></P><P>See: <A href="https://community.qlik.com/message/1054349">Re: collapse rows in excel pivot table - Nprinting</A></P><P></P><P>HTH - Daniel.</P></BODY></HTML> Tue, 21 Jun 2016 22:11:24 GMT Daniel_Jenkins 2016-06-21T22:11:24Z Collapse in Pivot table Nprinting? https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161200#M11631 <HTML><HEAD></HEAD><BODY><P>I have created excel report in Nprinting. I need always collapse but am unable to do . it is always expanded how can i collapse?</P></BODY></HTML> Tue, 21 Jun 2016 08:42:31 GMT https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161200#M11631 Anonymous 2016-06-21T08:42:31Z Re: Collapse in Pivot table Nprinting? https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161201#M11632 <HTML><HEAD></HEAD><BODY><P>Hi Lakshmi,</P><P></P><P>You will need to use XLSM format and write VBA code in the <EM>Workbook_Open</EM> event.</P><P></P><P>See: <A href="https://community.qlik.com/message/1054349">Re: collapse rows in excel pivot table - Nprinting</A></P><P></P><P>HTH - Daniel.</P></BODY></HTML> Tue, 21 Jun 2016 22:11:24 GMT https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161201#M11632 Daniel_Jenkins 2016-06-21T22:11:24Z Re: Collapse in Pivot table Nprinting? https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161202#M11633 <HTML><HEAD></HEAD><BODY><P>Hi thanks for your replay. I tried but it is not working.&nbsp; I saved file as&nbsp; "excel macro _enabled workbook" after reload task it is not collapsing.</P></BODY></HTML> Wed, 22 Jun 2016 05:33:56 GMT https://community.qlik.com/t5/Qlik-NPrinting/Collapse-in-Pivot-table-Nprinting/m-p/1161202#M11633 Anonymous 2016-06-22T05:33:56Z