Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Invalid Links
When using the delete links add-in, six out of seven links
found were successfully deleted. The remaining link returned the following error msg: Routine location error code: 6. Some defined name links may not be deleted. The deleted links reference sheet listed an internal link location of NA for this link. This link still appears when attempting to edit links. Any idea how to find and subsequently delete this invalid link? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Invalid Links
never used that add-in
but i have found that when your working with named ranges and several spreadsheets that thier will be times when the named ranges will cantain links with in them. if they ant their you can use ctrl-f and search for a "[" that should find any links but that may take some time if you got a big spreadsheet hope that helps -----Original Message----- When using the delete links add-in, six out of seven links found were successfully deleted. The remaining link returned the following error msg: Routine location error code: 6. Some defined name links may not be deleted. The deleted links reference sheet listed an internal link location of NA for this link. This link still appears when attempting to edit links. Any idea how to find and subsequently delete this invalid link? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Invalid Links
Stan,
You may have done this, but did you look in the Insert Name dialog box (Insert/Name/Define)? I've been in similar situations and have found defined names whose references are no longer valid. hth, Doug "stan sitek" wrote in message ... When using the delete links add-in, six out of seven links found were successfully deleted. The remaining link returned the following error msg: Routine location error code: 6. Some defined name links may not be deleted. The deleted links reference sheet listed an internal link location of NA for this link. This link still appears when attempting to edit links. Any idea how to find and subsequently delete this invalid link? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Invalid Links
See one more guess at your other post.
stan sitek wrote: When using the delete links add-in, six out of seven links found were successfully deleted. The remaining link returned the following error msg: Routine location error code: 6. Some defined name links may not be deleted. The deleted links reference sheet listed an internal link location of NA for this link. This link still appears when attempting to edit links. Any idea how to find and subsequently delete this invalid link? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Links | Excel Discussion (Misc queries) | |||
Breaking links leaving invalid reference #REF! in cell | Excel Discussion (Misc queries) | |||
Cant find & delete invalid formulas or links | Excel Discussion (Misc queries) | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
Deleting Links | Links and Linking in Excel |