Try F5 or Control-G/Special/Formulas/Errors

"Jerry Timm" wrote:

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.