I have a workbook with many links, around two thousand, and a number of them
only work when the source file is open. This is not the case of my using of
Indirect() on some of them making them not work because all of my links are
the same, along the format of ='Y:\*Path*\*[File name]**Worksheet Name*'$J$45
..

For example, half of the data in the second week of calculations does not
update, but the data in evey other week works perfectly. This update problem
is rectified if the "Week Two.xls" file is open. I also have a problem that
the first link to many of the weeks (but not all of them) does not work
unless the referenced workbook is open, although all of the other links to
the file are updated when the file is closed, and there is absolutely no
difference between the way the links look in Excel.

If you need more specific information I can provide it.

Ben Enfield