Excel formula referencing another sheet from the same template

guilhermetiscos — Sat, 16 Nov 2024 03:26:38 GMT

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

Re: Excel formula referencing another sheet from the same template

guilhermetiscos — Tue, 28 May 2019 19:28:52 GMT

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/

topic Re: Excel formula referencing another sheet from the same template in Qlik NPrinting

Excel formula referencing another sheet from the same template

Re: Excel formula referencing another sheet from the same template