Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get rid of an external link which I can't find?
I have a spreadsheet that *somewhere* has an external link.
I want to get rid of it, but I need to find the link first to check that I am not hard-coding over a formula that does actually need to change. However Excel 2002 is too stupid to show me the actual link. I can "Break the Link", but since the program refuses to actually direct me to the cell using the link, that option is no good. I have also tried using "Find" to look for the cell linking to the external sheet, but Excel can't find any matches. I have reviewed the list of defined names in "Insert Name" dialog box; none of them are external to the worksheet. This is driving me up the wall. I can't download the utility suggested in a previous posting, since I am using my work computer and there are strict rules on downloading anything, let along .xla files. Someone please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get rid of an external link which I can't find?
Check out this link. Bill Manville has a great addin for finding and removing
links... http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "Ray" wrote: I have a spreadsheet that *somewhere* has an external link. I want to get rid of it, but I need to find the link first to check that I am not hard-coding over a formula that does actually need to change. However Excel 2002 is too stupid to show me the actual link. I can "Break the Link", but since the program refuses to actually direct me to the cell using the link, that option is no good. I have also tried using "Find" to look for the cell linking to the external sheet, but Excel can't find any matches. I have reviewed the list of defined names in "Insert Name" dialog box; none of them are external to the worksheet. This is driving me up the wall. I can't download the utility suggested in a previous posting, since I am using my work computer and there are strict rules on downloading anything, let along .xla files. Someone please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Find Link Cells | Excel Discussion (Misc queries) | |||
Can't find Edit, links dialogue box to break the link | Excel Discussion (Misc queries) | |||
Create an external reference link with embedded variable | Excel Worksheet Functions | |||
External link using calculated cell value | Excel Worksheet Functions | |||
Cannot save external link values? | Excel Discussion (Misc queries) |