Serious Referencing Error

[MikeChicago]

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.

 

[Jan Karel Pieterse]

Hi MikeChicago,

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.

Sounds like a corrupted file to me!
Check out what I write near the bottom of this page:
http://www.jkp-ads.com/articles/CorruptFiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com