Broken links but they're not
 

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?

Broken links but they're not
 

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?

Broken links but they're not
 

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?