Module VI· Model Auditing & DebuggingAdvanced
Question

How do you debug a #REF! error cascade after row or column deletion?

Answer

Undo immediately if possible. If not, use Find for #REF!, trace dependents, and identify the deleted source row / column. Restore from backup or rebuild links from neighboring formulas. Check named ranges, charts, data tables, and hidden sheets. #REF! cascades often spread through summary tabs and sensitivities.