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

Similar Threads

Cumulative formula for word table 0
Finding Invalid References 1
invalid references 2
Excel 2003 dynamic named range for the values in a pie chart 1
persistent "invalid reference" error message 2
Finding one or more "Invalid References" in big spreadsheet 1
Formula with Invalid References Error Message 5
invalid reference error saving 2003 file in 2007 0

Top