When formulas are linked to other workbooks/cells that have been deleted, you will get a #REF error in Excel. To clear it, read our step by step guide here.
