Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-actual external links remain
Hello,
I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I have used external links in worksheet cells - like VLOOKUP etc. I have however removed those formulas, but nevertheless, when I open such a workbook, Excel wants still refresh the links. I have searched in worksheets, macros and Add-Ins for scraps of those links, but never found any. Today I created a new workbook, copied from an old workbook only one - more or less empty - sheet. I immediately saved the new book and reopened. All those old annoying links were copied to the new book!!! Where are they hidden? Is there any other solution than creating the workbook from scratch? I know, I can ignore to update the links, but still it is annoying. -- Håkan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-actual external links remain
Make some search with keywords "find link", you'll find many answers, e.g.
Paul's and Max's ones: Try Bill Manville's excellent "FindLink" utility? It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Max Singapore go to the edit menu and down near the bottom the links option should be NOT greyed out,click on that and you choose the break links option......or use find to find all references to other workbooks -- paul Regards, Stefi HBj ezt Ã*rta: Hello, I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I have used external links in worksheet cells - like VLOOKUP etc. I have however removed those formulas, but nevertheless, when I open such a workbook, Excel wants still refresh the links. I have searched in worksheets, macros and Add-Ins for scraps of those links, but never found any. Today I created a new workbook, copied from an old workbook only one - more or less empty - sheet. I immediately saved the new book and reopened. All those old annoying links were copied to the new book!!! Where are they hidden? Is there any other solution than creating the workbook from scratch? I know, I can ignore to update the links, but still it is annoying. -- HÃ¥kan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-actual external links remain
Found it, thanks.
And the program finds the links, but I can't break the link! Only options to "Update Now", "Open Source" and "Change Source..." Håkan "Stefi" wrote in message ... Make some search with keywords "find link", you'll find many answers, e.g. Paul's and Max's ones: Try Bill Manville's excellent "FindLink" utility? It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Max Singapore go to the edit menu and down near the bottom the links option should be NOT greyed out,click on that and you choose the break links option......or use find to find all references to other workbooks -- paul Regards, Stefi "HBj" ezt írta: Hello, I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I have used external links in worksheet cells - like VLOOKUP etc. I have however removed those formulas, but nevertheless, when I open such a workbook, Excel wants still refresh the links. I have searched in worksheets, macros and Add-Ins for scraps of those links, but never found any. Today I created a new workbook, copied from an old workbook only one - more or less empty - sheet. I immediately saved the new book and reopened. All those old annoying links were copied to the new book!!! Where are they hidden? Is there any other solution than creating the workbook from scratch? I know, I can ignore to update the links, but still it is annoying. -- Håkan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-actual external links remain
Where did it find the links? You have to delete or change formulae containing
references to external workbooks! Regards, Stefi HBj ezt Ã*rta: Found it, thanks. And the program finds the links, but I can't break the link! Only options to "Update Now", "Open Source" and "Change Source..." HÃ¥kan "Stefi" wrote in message ... Make some search with keywords "find link", you'll find many answers, e.g. Paul's and Max's ones: Try Bill Manville's excellent "FindLink" utility? It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Max Singapore go to the edit menu and down near the bottom the links option should be NOT greyed out,click on that and you choose the break links option......or use find to find all references to other workbooks -- paul Regards, Stefi "HBj" ezt Ã*rta: Hello, I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I have used external links in worksheet cells - like VLOOKUP etc. I have however removed those formulas, but nevertheless, when I open such a workbook, Excel wants still refresh the links. I have searched in worksheets, macros and Add-Ins for scraps of those links, but never found any. Today I created a new workbook, copied from an old workbook only one - more or less empty - sheet. I immediately saved the new book and reopened. All those old annoying links were copied to the new book!!! Where are they hidden? Is there any other solution than creating the workbook from scratch? I know, I can ignore to update the links, but still it is annoying. -- HÃ¥kan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-actual external links remain
Because all links were broken it didn't tell me where they are - only found.
I found on the net a better tool by which I was able to delete broken links. Thanks! Håkan "Stefi" wrote in message ... Where did it find the links? You have to delete or change formulae containing references to external workbooks! Regards, Stefi "HBj" ezt írta: Found it, thanks. And the program finds the links, but I can't break the link! Only options to "Update Now", "Open Source" and "Change Source..." Håkan "Stefi" wrote in message ... Make some search with keywords "find link", you'll find many answers, e.g. Paul's and Max's ones: Try Bill Manville's excellent "FindLink" utility? It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Max Singapore go to the edit menu and down near the bottom the links option should be NOT greyed out,click on that and you choose the break links option......or use find to find all references to other workbooks -- paul Regards, Stefi "HBj" ezt írta: Hello, I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I have used external links in worksheet cells - like VLOOKUP etc. I have however removed those formulas, but nevertheless, when I open such a workbook, Excel wants still refresh the links. I have searched in worksheets, macros and Add-Ins for scraps of those links, but never found any. Today I created a new workbook, copied from an old workbook only one - more or less empty - sheet. I immediately saved the new book and reopened. All those old annoying links were copied to the new book!!! Where are they hidden? Is there any other solution than creating the workbook from scratch? I know, I can ignore to update the links, but still it is annoying. -- Håkan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External links | Excel Discussion (Misc queries) | |||
External Links | Links and Linking in Excel | |||
#Value w external links | Excel Discussion (Misc queries) | |||
External Links | Excel Discussion (Misc queries) | |||
external links | Excel Worksheet Functions |