MS Excel Secrets - #REF! - Invalid Cell Reference Errors

Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. 

This happens most often when:
  1. Columns or rows containing data used in the formula are accidentally deleted.
  2. A formula has been moved or copied to another cell and the cell references are incorrect.
  3. Data used in a formula has been moved, leaving the function or formula with incorrect cell references
Read lots more  MS Excel Secrets

Solutions:
  1. Use the undo feature to recover lost data
  2. If the data cannot be recovered, re-enter the data and adjust the cell references if needed
  3. Correct the cell references for formulas that have been copied or moved
  4. Correct the cell references for formulas when the data has been moved

Related

REF Error 8130024316647128324

Post a Comment

  1. #Ref is a common thing and usually happens when we delete rows and columns without taking care of cells which point to them.

    Very useful post. Keep up the good work!

    ReplyDelete
    Replies
    1. Thanks for Your Feedback.We try our best for continuous improvement of this blog-log.

      Delete

SPAMMING will not be Appreciated.

emo-but-icon

Hot in week

Recent

Comments

Blog Archive

Our Channel

Contact Us

Name

Email *

Message *

Follow by Email

item