hi Jonathan,

indirect function will works only if the linked wb is open.

hth
regards from Brazil
Marcelo

"Jonathan" escreveu:

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