Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Broken Links | Setting up and Configuration of Excel | |||
Help with Broken Links | Excel Discussion (Misc queries) | |||
Broken Links.... | Excel Discussion (Misc queries) | |||
Broken Links | Excel Discussion (Misc queries) | |||
Links are broken and cannot fix | Excel Worksheet Functions |