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

"Jim Thomlinson" wrote:

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
--
HTH...

Jim Thomlinson


"Andy" wrote:

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?