Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing links to other workbooks-Excel 2000
I'm working with a spreadsheet/form in Excel 2000 (calculates estimated
relocation costs) that has an old link to a non-existent workbook -- it was developed from another spreadsheet but is a stand-alone form and there is no need to update, as must have been the case with the original. The resulting pop-ups are a problem. I don't work with queries or macros... at least, not until now, so don't know how to eliminate the unnecessary link(s). Any suggestions are appreciated. |
#2
|
|||
|
|||
Hi
goto: http://oaltd.co.uk/MVP/Default.htm and search for Findlink.zip (http://oaltd.co.uk/DLCount/DLCount.a...e=FindLink.zip) -- Regards Frank Kabel Frankfurt, Germany "ktroupe70" schrieb im Newsbeitrag ... I'm working with a spreadsheet/form in Excel 2000 (calculates estimated relocation costs) that has an old link to a non-existent workbook -- it was developed from another spreadsheet but is a stand-alone form and there is no need to update, as must have been the case with the original. The resulting pop-ups are a problem. I don't work with queries or macros... at least, not until now, so don't know how to eliminate the unnecessary link(s). Any suggestions are appreciated. |
#3
|
|||
|
|||
Try going to Edit | Links.
This should list all the links in the workbook. select the link you want and pick break link. tj "ktroupe70" wrote: I'm working with a spreadsheet/form in Excel 2000 (calculates estimated relocation costs) that has an old link to a non-existent workbook -- it was developed from another spreadsheet but is a stand-alone form and there is no need to update, as must have been the case with the original. The resulting pop-ups are a problem. I don't work with queries or macros... at least, not until now, so don't know how to eliminate the unnecessary link(s). Any suggestions are appreciated. |
#4
|
|||
|
|||
Frank, in researching my problem (cancelling a link in Excel2000) I saw your
name often, so I thought I'd give your suggestion. It did n't work for me. I have a book that I don't want linked to anything. Break Link is not available to me under EDIT, LINKS. Any other suggestions? "Frank Kabel" wrote: Hi goto: http://oaltd.co.uk/MVP/Default.htm and search for Findlink.zip (http://oaltd.co.uk/DLCount/DLCount.a...e=FindLink.zip) -- Regards Frank Kabel Frankfurt, Germany "ktroupe70" schrieb im Newsbeitrag ... I'm working with a spreadsheet/form in Excel 2000 (calculates estimated relocation costs) that has an old link to a non-existent workbook -- it was developed from another spreadsheet but is a stand-alone form and there is no need to update, as must have been the case with the original. The resulting pop-ups are a problem. I don't work with queries or macros... at least, not until now, so don't know how to eliminate the unnecessary link(s). Any suggestions are appreciated. |
#5
|
|||
|
|||
Try that findlink.zip program.
It'll look for links and ask what should be done with them (convert to values?). T wrote: Frank, in researching my problem (cancelling a link in Excel2000) I saw your name often, so I thought I'd give your suggestion. It did n't work for me. I have a book that I don't want linked to anything. Break Link is not available to me under EDIT, LINKS. Any other suggestions? "Frank Kabel" wrote: Hi goto: http://oaltd.co.uk/MVP/Default.htm and search for Findlink.zip (http://oaltd.co.uk/DLCount/DLCount.a...e=FindLink.zip) -- Regards Frank Kabel Frankfurt, Germany "ktroupe70" schrieb im Newsbeitrag ... I'm working with a spreadsheet/form in Excel 2000 (calculates estimated relocation costs) that has an old link to a non-existent workbook -- it was developed from another spreadsheet but is a stand-alone form and there is no need to update, as must have been the case with the original. The resulting pop-ups are a problem. I don't work with queries or macros... at least, not until now, so don't know how to eliminate the unnecessary link(s). Any suggestions are appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |