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.