Sumproduct work with closed files. I use concatenate to build the external link.
I dont know how to use indirect in this way. Does it still need to have the file open?