#REF in Excel! How to fix error?
Braxorn · Last updated 2026-11-22 · English
#REF! Indicates an invalid cell reference. The address required by the formula may have been lost due to a deleted row, column or moved data. The correct solution is to re-determine what data the formula should use.
What can you do?
- If the error has just occurred, examine the last delete or move operation; undo if appropriate.
- #REF! in the formula bar. Locate the last section and compare it with the old version or backup.
- Restore the correct cell reference. Examine whether the results linked to the same cell have also improved.
A small example
If a sales formula multiplies quantity by unit price, deleting the price column may break the reference. Redirecting to another random column hides the error but does not correct the calculation.
What to watch for
#REF! Do not replace the expression with all zeros. Assuming missing data as zero may render the report incorrect.
Check the result
Calculate a sample row manually and compare it with the new formula result.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file