Create link with sheet which is not inserted into workbook

[Guest]

I have a workbook containing Sheet 1, Sheet 2, Sheet3. If I write in cell A1
"March"
of Sheet 1 and then put formula (=Sheet1!A1) in A1 of Sheet 2 it gives
"March" in result. And if I put formula (=Sheet4!A1) then it result #REF!
because Sheet 4 is not inserted. Is it possible ? If I insert Sheet 4 and
write "March" in cell A1 automatically #REF! turns into "March" without
changing formula of cell A1 of Sheet 2.

Jai

 

[Guest]

I don't believe so,
if you click on the cell and hit enter it will recognise it
but using the indirect function
will update the cell as soon as the first calc is done
=indirect("Sheet4!A1")
will give you the ref error until the first calc after enter sheet 4

 

[Guest]

Thankyou so much bj for explaining the answer. It will fulfil my need.