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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
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