How to find which formula in Excel sheet has an invalid reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been receiving an error maessage that my worksheet contains one or
more invalid references. (Everytime a new data value is entered) And that I
should varify that my formulas contain valid references . The trouble is
that my workbook contains lots of formulas and I have no idea where to look
for the invalid reference. It seems that if Excel can recognize that there
are invalid references, it should be able to tell me where they are.
 
Back
Top