A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file. Seems other EXCEL files should be
open, otherwise, reference error occurs. Because there are many other EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without opening
other
files?

Thanks,