Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rogue Link
I have created a workbook that calls information from several others. My
problem is there appears to be a rogue link within the workbook which is for a workbook that no longer exists.. I believe this is a remnant from somewhere within the development stage of the application. Although this link is not causing a direct problem it does cause an error 'cannot find' type error on startup - which is annoying! I have done all the usual searches, of worksheets/macros etc, but cannot seem to find it. As the error message only appears once I am assuming there is only one occurence with the workbook. Anyone got any other ideas on how to find? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rogue Link
On 1 Apr, 11:34, SyZyGy wrote:
I have created a workbook that calls information from several others. My problem is there appears to be a rogue link within the workbook which is for a workbook that no longer exists.. I believe this is a remnant from somewhere within the development stage of the application. Although this link is not causing a direct problem it does cause an error 'cannot find' type error on startup - which is annoying! I have done all the usual searches, of worksheets/macros etc, but cannot seem to find it. As the error message only appears once I am assuming there is only one occurence with the workbook. Anyone got any other ideas on how to find? i down loaded a file called findlink.xla which searches the workbook for all links i am not sure where i had it from but search the web for it HTH kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rogue Link
Thanks Kevin
I found findlink.xla. Worked OK, but it did not find the rogue link! This is a strange one "kevcar40" wrote: On 1 Apr, 11:34, SyZyGy wrote: I have created a workbook that calls information from several others. My problem is there appears to be a rogue link within the workbook which is for a workbook that no longer exists.. I believe this is a remnant from somewhere within the development stage of the application. Although this link is not causing a direct problem it does cause an error 'cannot find' type error on startup - which is annoying! I have done all the usual searches, of worksheets/macros etc, but cannot seem to find it. As the error message only appears once I am assuming there is only one occurence with the workbook. Anyone got any other ideas on how to find? i down loaded a file called findlink.xla which searches the workbook for all links i am not sure where i had it from but search the web for it HTH kevin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rogue Link
On 1 Apr, 13:26, SyZyGy wrote:
Thanks Kevin I found findlink.xla. Worked OK, but it did not find the rogue link! This is a strange one "kevcar40" wrote: On 1 Apr, 11:34, SyZyGy wrote: I have created a workbook that calls information from several others. My problem is there appears to be a rogue link within the workbook which is for a workbook that no longer exists.. I believe this is a remnant from somewhere within the development stage of the application. Although this link is not causing a direct problem it does cause an error 'cannot find' type error on startup - which is annoying! I have done all the usual searches, of worksheets/macros etc, but cannot seem to find it. As the error message only appears once I am assuming there is only one occurence with the workbook. Anyone got any other ideas on how to find? i down loaded a file called findlink.xla which searches the workbook for all links i am not sure where i had it from but search the web for it HTH kevin- Hide quoted text - - Show quoted text - have you tried changing the source? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Rogue Password on Properties and References | Excel Discussion (Misc queries) | |||
rogue links appear in excel | Excel Worksheet Functions |