this is really Excel question - not NPrinitng question.
I will attempt to answer it and i will say that it depends how you set your references.
What you are doing now is setting reference to a excel document together with the path where document is stored. From my experience i was always able to avoid hardcoding the path and was able to have a reference to the same document.
Could you please provide us with the screenshot of your formula in NPrinting template editor - the one you have already provided is only result, and we need also to see how you have set it up.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Thank you for your help, and sorry, my mistake for not putting all the evidences:
Here is the print SS of the NPrinting Designer. As you can see, the formula is not hardcoded to the path of the template file:
And here is the generated report after running the Preview:
I have other reports that this 'formula reference' works as expected, the only difference I see is the use of a Table as a Level in this one. Could this be the source of the error? I used this functionality because I need the formulas from F5:M5 to be replicated to the new lines created from the origin table (a simple Straight table).