I have created excel report in Nprinting. I need always collapse but am unable to do . it is always expanded how can i collapse?
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.
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.
Retrieving data ...