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!