I have a spreadsheet that references another workbook (by server name). When
I close the main workbook, it seems fine. When I reopen however, the formula
is no longer linked. I have to double click the cell, then hit enter, and it
works fine. I have to do this for every line however. Can someone tell me
what the problem is? Here is the formula for your reference.

=IF(ISNA(IF(C42="","",IF($B$3="","Plant?",(VLOOKUP (K42,'\\okmain\Everyone_Orval_Kent$\MM
Forms\[Std Costs
010107A.xls]Costs'!$C$2:$V$10258,3,FALSE)/10000))))=TRUE,"Invalid
Plant",IF(C42="","",IF($B$3="","Plant?",(VLOOKUP(K 42,'\\okmain\Everyone_Orval_Kent$\MM Forms\[Std Costs 010107A.xls]Costs'!$C$2:$V$10258,3,FALSE)/10000))))