topic Re: Excel Template Rows are shifting down.. help in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Excel-Template-Rows-are-shifting-down-help/m-p/1234716#M13658 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I have found the solution to my issue :</P><P></P><P>I needed to uncheck the 'Expand Range' check box in the Properties section :</P><P></P><P><IMG alt="nprint_properties.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149235_nprint_properties.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 12 Jan 2017 10:25:35 GMT 2017-01-12T10:25:35Z Excel Template Rows are shifting down.. help https://community.qlik.com/t5/Qlik-NPrinting/Excel-Template-Rows-are-shifting-down-help/m-p/1234715#M13657 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to insert a qlikview chart into an existing excel template.&nbsp; Each week I need to overwrite three columns, but when I preview the Nprint template it has shifted the whole spreadsheet down.</P><P></P><P>This is the original template. On a daily basis I need to insert and overwrite the cells in O10, P10 &amp; Q10</P><P></P><P><IMG alt="nprint_temp1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149224_nprint_temp1.jpg" style="height: 381px; width: 620px;" /></P><P></P><P>However, when I try and place the straight table 'cells' into the template this happens :</P><P></P><P><IMG alt="nprint_temp2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/149234_nprint_temp2.jpg" style="height: auto;" /></P><P></P><P></P><P>the&nbsp; rows are shifting down which is incorrect.</P><P></P><P>Can anyone help on this?</P><P></P><P>Many thanks!</P></BODY></HTML> Thu, 12 Jan 2017 10:14:07 GMT https://community.qlik.com/t5/Qlik-NPrinting/Excel-Template-Rows-are-shifting-down-help/m-p/1234715#M13657 2017-01-12T10:14:07Z Re: Excel Template Rows are shifting down.. help https://community.qlik.com/t5/Qlik-NPrinting/Excel-Template-Rows-are-shifting-down-help/m-p/1234716#M13658 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I have found the solution to my issue :</P><P></P><P>I needed to uncheck the 'Expand Range' check box in the Properties section :</P><P></P><P><IMG alt="nprint_properties.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149235_nprint_properties.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 12 Jan 2017 10:25:35 GMT https://community.qlik.com/t5/Qlik-NPrinting/Excel-Template-Rows-are-shifting-down-help/m-p/1234716#M13658 2017-01-12T10:25:35Z