This message may not be related to anything in your worksheets.

I opened the file and didn't see any warning.

So I went into the VBE (alt-f11) and with the workbook's project selected,
clicked on:

Tools|References

You have a reference to OLE Automation.

I removed that reference, saved and reopened your workbook. I didn't get any
error messages.

But the bad news is that I don't remember how to do the same thing in xl95. I
looked at one of my old reference (no pun intended!) books and it didn't offer
any help.

I uploaded the file to:
http://www.filedropper.com/clarkworkbook2

If that works ok, maybe it's worth looking in xl95's help for references????

Hope it helped...

Mason C wrote:

On Mon, 12 Oct 2009 15:59:53 -0500, Dave Peterson
wrote:

If you want to zip the file and send me a copy (privately--not to the
newsgroup), you can.

Dave,

In response to your too kind offer, I stripped the workbook down to
the offending sheet and stripped that sheet to a minimum.

The offending bit that's left contains:

column A of dates
column C with the formula: =IF(A1=Today(),99,A1)
and a graph (originally quite complicated)

The "99" serves to mark Today on the graph.
A very nice touch for my purpose if I do say so but....

It makes any entry anywhere cause an "External reference not valid"

What's wrong with my clever trick?

The sheet can be seen at http://frontal-lobe.info/misc/clarkworkbook.xls

The mystery evolves on a dark and stormy night in northern California.

Thanks again, Dave,

Mason


Mason C wrote:
Mason Clark


The original post:

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.

--

Dave Peterson