I'm using Nprinting to distribute Excel reports. and recently I encountered a problem with usingpre saved excel formats in Nprinting. I have saved an excel with formulas in several columns(lets say column M to W), and I want Nprinting to dump the data from Qlikview object onto the excel sheets in desired columns(e.g column A to I).
Nprinting, on the other hand, while copying the chart object inserts new rows and this in turn pushes down all the formulas.I have tried inserting Levels first, but that also didn't help.
If you see the attached excel, I want to insert Qlik Object on the Data-Day and Data-Week tabs, and the Day and Week Tabs
respectively would update and perform the calculations in Columns M to W, But since Nprinting inserts new rows, when copying the Object, the formulas are pushed down and the calculation starts from row M11 instead of row M1.
Can anyone please suggest a way to lock the rows in this case or if there is anyother workaround? TIA