Hello,

I use the OFFSET function in workbook1, with a reference in workbook2.
When I open only workbook1 (without opening workbook2) it does not give me a
result but only a #Value.
Does not matter ig I chose "update" or "do not update".
As soon as Workbook2 is open, the results shows...

I have no problem of that kind with the lookup function...

I there any way to solve this ?