I am using the offset function, the reference is another worksheet. The
formula gives a value when the other worksheet is open but when I reopen the
worksheet with the offset function referencing the other worksheet, there is
a Value error.

Is it not possible to use offset function referencing another worksheet?

THanks