Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just found that using Named Ranges fixes the issue: https://www.ablebits.com/office-addins-blog/2017/07/11/excel-name-named-range-define-use/
Just found that using Named Ranges fixes the issue: https://www.ablebits.com/office-addins-blog/2017/07/11/excel-name-named-range-define-use/