I have one master workbook and several (children) others from where the
master grabs the info.  I have created formulas in the master workbook to
link numbers from the children.  The info from the child workbook are @sum
formulas.  I made sure that even when you insert rows in the child workbook
that the formula still adds the correct rows.  Now, when I tested this with
the master, it worked fine.  It updates the master correctly even if I insert
rows in the child workbook.  But now, after several months, I checked the
master and it's not correct.  The formulas in the master linking it to the
child don't even refer to the sum.

Example:  
In the Master book
Cell B3 is =SUM('S:\Marketing\2004 Budget\2004 Planning
Documents\[CORPORATE.xls]Sheet1'!$F$14)
But the info I want from CORPORATE.xls is now in F17.  Somehow, when rows
were inserted, it didn't update the Master formula.  So the info in the
master is wrong because it's not getting the total which is in F17 but just
the figure in F14.  Yet, when I test it, it works.

When the dialog box opens and asks if you want to update links and you click
Do not update, can that be the reason why?  I'm wondering if the Do not
update gets click often that that's where the discrepancy is coming from?

Can someone help?