Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
guilhermetiscos
Contributor II
Contributor II

Excel formula referencing another sheet from the same template

Hello,

Inside an Excel Report template I added a Table Box as a level ir order to add an excel formula that expends vertically as the table box is filled.  The problem is that the formula references another sheet from the same template and when I run the preview, it results in a report with reference error, because the formula ends up with a hard coded reference to the .temp file created to generate the report. If the formula reference stays within the same sheet, the error doesn't occur. I tried multiple workarounds but none seemed to work. Is this an expected behavior ou can it be fixed? Added the GIF attached as evidence.

Just in case the attachment doesn't work, here is the link to the GIF:

https://www.dropbox.com/s/p470mi9luh7739s/NPrinting%20reference%20error.gif?dl=0

Labels (1)
1 Solution

Accepted Solutions
1 Reply
guilhermetiscos
Contributor II
Contributor II
Author