On Sun, 11 Oct 2009 07:19:46 -0500, Dave Peterson
wrote:

Can you find someone with xl97 or greater and ask them to see if they can use
the Bill's program and look at your file?

Don't know anyone I'd bother to do that (I would scare them :-).

I replaced all the 3 or 4 " .xls " and " #ref! " in the file
(binary search/replace) with no effect -

sheet seems undamaged but still gives " External reference not valid" warning.

I can survive annoyed with the extra mouse clicks. Thanks anyway.

Mason Clark


Mason C wrote:

On Sat, 10 Oct 2009 17:43:54 -0500, Dave Peterson
wrote:

I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

But I _think_ that it requires xl97 or newer.

If you try it and it doesn't work, maybe you can search through formulas for:
.xls
[
#ref!

Maybe that'll help you find a formula that is broken.

Dave:

FindLink doesn't work in my Excel version. (says, "not a valid add-in")
The searches for xls, [ , #ref! find nothing.
The sheet is small enough that I have scanned it for any reference: nothing.

Thanks for the suggestions anyway.

Mason Clark


Mason C wrote:

I have a sheet that persistently reports, "External reference is not valid"

I can't find the invalid reference. How can I find it?

[Excel for Windows 95 Version 7.0]

Thanks for any suggestion.