When you delete a row or column, excel updates all formula references to the
new addresses and replaces references to the deleted cells with #REF.

Any way to programatically disable this?

My specific problem: I've got a workbook that does a whole bunch of number
crunching based on a report pasted into one of the worksheets. The app that
generates that report (MS Money) now has a few more columns & rows I don't
need. I added code to delete this, but excel updates all the lookup
references into that sheet, thus throwing everything off. I looked at
updating all the references and avoiding the deletes, but this ends up being
too painful (lots of lookups on lookups).

So, my idea is to disable the reference updates, do all my deletions &
slashing on the one sheet, then re-enable reference updates, all the
references still pointing where they previously had.