Question: what does this mean in excel #ref?
Answer: The #REF! error shows when a formula refers to a cell that's not valid . This happens most often when cells that were referenced by formulas get deleted, or pasted over.