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.