Thank you. That was an excellent referral.

"Frank Kabel" wrote:

Hi
yes it has to be open. For workarounds see:
http://www.dicks-blog.com/archives/2...oks/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany

briancrosier wrote:
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.