Linking Issues
 

In my spreadsheet I have links with files that have very similar names, but
in different directories -- IE Bus A - Forecast 1, Bus A - Forecast 2 -- and
is pulling the same data from each Spreadsheet:

A B
1 =c:\Jan\Bus A - Forecast 1!C2
2 =c:\Feb\Bus A - Forecast 2!C2

Here is the issue -- Every time I either (a) insert a line in the
spreadsheet or (b) open up either linked file -- the cell with the linked
data turns to #VALUE! and then I have to open each file to refresh all of the
links.

Any ideas on why this is happening.