#REF! Error

Tags: #<Tag:0x00007f8b25a84618> #<Tag:0x00007f8b25a8b120>
#1

image
image.png550×697 30.4 KB

We have multiple tables, they can be rendered in different order. Now we have encountered a problem (#Ref! Error when referencing sheet) with such an arrangement of tables, the first table has an error #REF! Is there any way to fix this without usingEffect solution?

Demo: https://jsfiddle.net/6hjcgdos/75/

#2

Hi @mbdoy213

You are setting a reference for the main sheet Sheet1 within Sheet2 before the Sheet1 is created. That is why you get the error. You will need to set up the reference once the Sheet1 is created.

#3