Referencing Error
 

I have a complex spreadsheet with many sheets linked together. Sometimes
when I delete rows on one sheet the links do not update. For example, if
cell
Sheet2!b7=Sheet1!g10 and then I delete rows 2 & 3 on "Sheet1", the formula
in Sheet2!b7 does not update to Sheet1!g8 but still references row 10 even
though everything has moved up on Sheet1.

Does anyone know what this happens? Thanks.