Formula with cell reference not working

Well that works...partially. After a little more debugging it looks like the file has to be open . Is there a way to have this coded so I can just open the one file, and the foruma will automatically look in the other files without them having to be open???

Thanks again for the help.

Hi

INDIRECT requires the file to be open before it will work.

I believe that morefunc has some addins that will work with a closed file, but I've never used them.

rylo