1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

#REF! - Invalid Cell Reference Errors


#REF! Error Message Excel

#REF! Error Message Excel

© Ted French

Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. This happens most often when:

  • columns or rows containing data used in the formula are accidentally deleted.

  • a formula has been moved or copied to another cell and the cell references are incorrect.

  • data used in a formula has been moved, leaving the function or formula with incorrect cell references


  • use the undo feature to recover lost data

  • if the data cannot be recovered, re-enter the data and adjust the cell references if needed

  • correct the cell references for formulas that have been copied or moved

  • correct the cell references for formulas when the data has been moved

Related Articles

©2014 About.com. All rights reserved.