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?