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

J

Jerry Timm

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top