Thread: External reference is not valid ???
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default External reference is not valid ???
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.


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.

--

Dave Peterson
Reply With QuoteReply With Quote