I have a column where all formulas are the same except row number. Some of
the formulas are returning '#N/A' when I open the file. The formulas link to
another file. When I open the other file, the values update correctly. Only
about a dozen blocks are doing this. All other blocks are calculating
correctly before I open the source file. If I open the Error Checkingbox, it
says 'A value is not available to the formula or function'