invalid references in formula
 

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!

invalid references in formula
 

You start by posting the formula and some sample data.

--
HTH

Bob Phillips

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

"JK" wrote in message
...
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!

invalid references in formula
 

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JK" wrote:
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!