Does file need to be open for INDIRECT to another workbook to work

[briancrosier]

That's the question. I am using indirect references to lookup from another
workbook. It seems as though the files must be open. Is there any way
around this without using script.

 

[Frank Kabel]

Hi
yes it has to be open. For workarounds see:
http://www.dicks-blog.com/archives/2004/12/01/indirect-and-closed-workbooks/trackback/

 

[briancrosier]

Thank you. That was an excellent referral.

Hi
yes it has to be open. For workarounds see:
http://www.dicks-blog.com/archives/2004/12/01/indirect-and-closed-workbooks/trackback/