excel error message

[excelista]

how do I locate an outdated link in a worksheet? I get a message when I save
that there is a bad link. The worksheet saves OK, but I'd like to get rid of
the message and the link that is causing it.

 

[Mike H]

Try:-

Edit|Links

Break the offending link from there.

Mike

 

[Dave Peterson]

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