MS Excel Secrets - #REF! - Invalid Cell Reference Errors
https://ingenuitydias.blogspot.com/2014/03/ms-excel-secrets-ref-invalid-cell.html
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
Read lots more MS Excel Secrets
Solutions:
Solutions:
- 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
Posts
#Ref is a common thing and usually happens when we delete rows and columns without taking care of cells which point to them.
ReplyDeleteVery useful post. Keep up the good work!
Thanks for Your Feedback.We try our best for continuous improvement of this blog-log.
Delete