Offset function referencing worksheet

[Guest]

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

 

[Ragdyer]

There are a number of functions that don't work with closed WBs, notably
Indirect(), Sumif(), and, as you've learned, Offset().

Post your formula so that other options can be suggested.