Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Template Rows are shifting down.. help

Hi,

I am trying to insert a qlikview chart into an existing excel template.  Each week I need to overwrite three columns, but when I preview the Nprint template it has shifted the whole spreadsheet down.

This is the original template. On a daily basis I need to insert and overwrite the cells in O10, P10 & Q10

nprint_temp1.jpg

However, when I try and place the straight table 'cells' into the template this happens :

nprint_temp2.jpg

the  rows are shifting down which is incorrect.

Can anyone help on this?

Many thanks!

1 Reply
Not applicable
Author

Hi,  I have found the solution to my issue :

I needed to uncheck the 'Expand Range' check box in the Properties section :

nprint_properties.PNG