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.