I have a problem when trying to link to other workbooks using the "Indirect"
function.

Only when the linked book is open will the formula return the linked value.
If the linked book is not open, I will get #REF as a result.

Is it not possible to link to other workbooks using "Indirect"?


Cheers,
Jonathan