Could the OFFSET function be used with external references ? Everything
OK when the external workbook is open, but #VALUE is returned when not.
I want OFFSET to work when the other workbook is closed.

Here is an example :

"Workbook1.xls" contains
A1 : ='BOB
B1 : ='ROGER

"Workbook2.xls" contains (with other source opened)
A1 : =OFFSET([Workbook1.xls]Sheet1!A1; 1; 0)

= Return "ROGER" when workbook1.xls is open
= Return #VALUE otherwise

Is there any workaround for this problem ? Thanks