I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
And if you're working with names, I'd get this, too:
Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
NameManager.Zip from
http://www.oaltd.co.uk/mvp
The findlink program does a better job of finding bad links (including
references to bad files/folders) and the name manager will make it easier to
clean things up (if you find stuff to clean up in the names).
ck13 wrote:
Hi,
I got this error message when i close my workbook: "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."
The funny thing is that this error message pop out only when i save and
close the workbook on certain worksheets. E.g. I have worksheet a, b, c and
d. When i am either on sheet a and d, i saved the file and close the book at
that sheet, the error message did not pop out. However when I performed
similar actions on either of the other 2 sheets, the error message appear.
Anyone have this problem or anyone knows what could the problem be? I am
running on 2003.
I followed a thread somewhere on this solution by Max and it did not work
out (no issue with the formula and the defined name):
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
---
--
Dave Peterson