I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
to search for links to the other workbooks.

And Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

To look for problems in the names.



Jeanne wrote:

I have a spreadsheet that has formulas and links to another page in the
spreadsheet. The other spreadsheet has a link to another workbook. On the
2nd worksheet of the work book I get an error message box "A formula in this
worksheet contains one or more invalid references. Verify that your formulas
contain a vaild path, workbook, range name, and cell reference. I have
reviewed every single cell, cleared all formats and formulas in all the
unused cells. The message is not consistant about appearing. I continually
have problems with my data changing on me after I save and close. It is a
very large spreadsheet. would hate to have to recreate. Is there anyway for
me to get Excel to tell me where the error is? It only allows me to click
ok. It does not come up with the circular reference box to check my formulas.

--

Dave Peterson