topic nPrinting changes ranges in QlikView https://community.qlik.com/t5/QlikView/nPrinting-changes-ranges/m-p/1299598#M843200 <HTML><HEAD></HEAD><BODY><P>So I have an nPrinting app that dumps the correct data into an excel file using a template file.</P><P></P><P>The template file has the charts to be added in tab 1 and in tab 2, the info collated from tab 1 using a hlookup populate the excel table.</P><P>This tab 2 has a number of hlookups.</P><P></P><P>The Template has the correct hlookups on tab 2.</P><P>When nPrinting does its dump and the newly created excel file is created, the vlookups change to the last empty cell.</P><P></P><P>So realistically, =HLOOKUP(Output!D$1,'raw data'!$C$1:$BP2,$A2,FALSE) is in the template (nPrinting shouldnt have to do anything with this sheet either.</P><P></P><P>When nPrinting does its job =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) appears in Cell BQ2 and all of BQ is now changed.</P><P></P><P>Attached are the template and output for a better example.</P><P></P><P>Any help would be appreciated.</P><P></P><P>I could manually change it from =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) to =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP2,$A2,FALSE) manually and expand that row but i shouldnt have to.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bobbydave 2020-11-25T16:16:04Z nPrinting changes ranges https://community.qlik.com/t5/QlikView/nPrinting-changes-ranges/m-p/1299598#M843200 <HTML><HEAD></HEAD><BODY><P>So I have an nPrinting app that dumps the correct data into an excel file using a template file.</P><P></P><P>The template file has the charts to be added in tab 1 and in tab 2, the info collated from tab 1 using a hlookup populate the excel table.</P><P>This tab 2 has a number of hlookups.</P><P></P><P>The Template has the correct hlookups on tab 2.</P><P>When nPrinting does its dump and the newly created excel file is created, the vlookups change to the last empty cell.</P><P></P><P>So realistically, =HLOOKUP(Output!D$1,'raw data'!$C$1:$BP2,$A2,FALSE) is in the template (nPrinting shouldnt have to do anything with this sheet either.</P><P></P><P>When nPrinting does its job =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) appears in Cell BQ2 and all of BQ is now changed.</P><P></P><P>Attached are the template and output for a better example.</P><P></P><P>Any help would be appreciated.</P><P></P><P>I could manually change it from =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP58,$A2,FALSE) to =HLOOKUP(Output!BQ$1,'raw data'!$C$1:$BP2,$A2,FALSE) manually and expand that row but i shouldnt have to.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/nPrinting-changes-ranges/m-p/1299598#M843200 bobbydave 2020-11-25T16:16:04Z