The #REF error occurs in Microsoft Excel when a formula refers to an invalid cell. This usually happens when cells that were referenced by formulas get removed or ...

Build bulletproof workbooks with named ranges, dynamic tables, and Excel's built-in error-checking tools.