Broken links but they're not

[Andy]

When i open a .xls I chose to update values and get an error that the links
cannot be updated. It only looks at two different files and when I go to edit
links, the status is all OK?

 

[Jim Thomlinson]

Perhaps there are links that you are unaware of. Named ranges are a good
place to look To that end Check out this link. It finda all links in a
worksheet.

http://www.oaltd.co.uk/MVP/

Download FindLinks

 

[Andy]

Brillant, thanks! The link it found definitely wasn't there in the edt links
section, but this found it. Problem solved, thanks again.