0 Replies Latest reply: Nov 24, 2016 12:18 PM by Walter Yip RSS

    NPrinting 16 SR5 excel pivot table named range (Bug?)

    Walter Yip

      After upgrading the NPrinting 16 from SR4 to SR5, when I follow the tutorial of creating excel pivot table as below:

      How to Create an Excel PivotTable Report

      In the tutorial, I have set the named range for looping the data from qvw. During the SR4, the named range is able to extend and the pivot table could reference the named range automatically. However, in SR5 a duplicated named range is created with named scope's worksheet which range is not extended. Therefore, the pivot table is reference to it and only show few lines.

       

      Anyone could help? Is it a bug of SR5? I am going to downgrade to SR4 because of this issue.