invalid references in formula

[JK]

I got the following message in excel:
"A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name and
cell reference."

How do I check and fix the error?

Thanks!

 

[Bob Phillips]

You start by posting the formula and some sample data.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Max]

Some thoughts ..

Press F5 > Special. In the "Go To Special" dialog, check "Formulas", then
uncheck all indented options except Errors*, then click OK. This will select
all formulas with errors on the sheet, if any. Either press to delete** all
at one go, or format these cells with say, red fill, for closer individual
inspection / fixing later. Repeat for each sheet ..
*ie uncheck: Numbers, Text, Logicals
**you would probably need to, for eg: re-copy the formulas down from the top
row (assuming these are still good, of course)

If you have defined / named ranges ..

Insert a new sheet, select A1, then click Insert > Name > Paste > Paste List
Check / note the pasted list for any defined range(s) with #REF! errors

Then click Insert > Name > Define, select these defined ranges (one at a
time), and either click to delete (or fix as appropriate within the "Refers
to" box)