If a referenced cell is deleted (delete row, column, sheet) the referencing cells show #REF! - no warning is issued.
technically this is OK, but frustrating for users, as this error is often only detected much later and reconstruction of the sheet is cumbersome if possible at all.
Any ideas?