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
---