View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Invalid external reference message

Hi Lawrence

Download a copy of Bill Manville's Findlink.xla and use that to show you
where the link exists and delete or amend it.
You can find the zip file at
http://www.bmsltd.ie/MVP/Default.htm

--
Regards
Roger Govier



"Laurence Lombard" wrote in message
...
When I close this workbook I get the message "Your formula contains an
invalid external reference to a worksheet. Verify the path, workbook, and
range name or cell reference are correct and try again". The error does
not seem to cause a critiacal problem. It gives no indication where the
problem is. How do I go about finding the problem formula.

Thanks
Laurence