Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
How to find the linked cell in EXcel
Hi,
When I open a excel file, there is prompt indicating there are link in this file. Since this file has so much sheet and data, is there anyway that I can use it in Macro to find this linked cell ? Thanks xk |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
How to find the linked cell in EXcel
Hi xk,
It isn't hard to find links without a macro. Simply use Edit|Links and you'll usually be able to see the first source file's path and filename listed against 'source file:'. If your workbook is linked to more than one file, selecting each in turn will reveal it full details. So, now all you need to do is a 'find' for those. Cheers -- macropod [MVP - Microsoft Word] "xk" wrote in message ... Hi, When I open a excel file, there is prompt indicating there are link in this file. Since this file has so much sheet and data, is there anyway that I can use it in Macro to find this linked cell ? Thanks xk |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
How to find the linked cell in EXcel
Hi, macropod,
Thanks for your reply. But this case is just not that simple. I did Edit/Link, it shows as the below Source Type Updated Status Adj Worksheet A Unkonwn And there is no any info for Location actually, no such source file exists. And there are links which are between the sheets in this file, not with the other file. But it always gets prompt which ask to "update" or "unpdated" with the link of out source. Have any idea about this issue? Thanks xk "macropod" wrote: Hi xk, It isn't hard to find links without a macro. Simply use Edit|Links and you'll usually be able to see the first source file's path and filename listed against 'source file:'. If your workbook is linked to more than one file, selecting each in turn will reveal it full details. So, now all you need to do is a 'find' for those. Cheers -- macropod [MVP - Microsoft Word] "xk" wrote in message ... Hi, When I open a excel file, there is prompt indicating there are link in this file. Since this file has so much sheet and data, is there anyway that I can use it in Macro to find this linked cell ? Thanks xk |
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
How to find the linked cell in EXcel
Hi xk,
Curious. In that case, try doing a search for any cells containing ':\' in a formula. -- macropod [MVP - Microsoft Word] "xk" wrote in message ... Hi, macropod, Thanks for your reply. But this case is just not that simple. I did Edit/Link, it shows as the below Source Type Updated Status Adj Worksheet A Unkonwn And there is no any info for Location actually, no such source file exists. And there are links which are between the sheets in this file, not with the other file. But it always gets prompt which ask to "update" or "unpdated" with the link of out source. Have any idea about this issue? Thanks xk |
#5
Posted to microsoft.public.excel.links
|
|||
|
|||
How to find the linked cell in EXcel
Hi XK,
You might also find Bill Manville's FindLInk addin useful. It's available at: http://www.oaltd.co.uk/MVP/Default.htm Cheers -- macropod [MVP - Microsoft Word] "xk" wrote in message ... Hi, macropod, Thanks for your reply. But this case is just not that simple. I did Edit/Link, it shows as the below Source Type Updated Status Adj Worksheet A Unkonwn And there is no any info for Location actually, no such source file exists. And there are links which are between the sheets in this file, not with the other file. But it always gets prompt which ask to "update" or "unpdated" with the link of out source. Have any idea about this issue? Thanks xk "macropod" wrote: Hi xk, It isn't hard to find links without a macro. Simply use Edit|Links and you'll usually be able to see the first source file's path and filename listed against 'source file:'. If your workbook is linked to more than one file, selecting each in turn will reveal it full details. So, now all you need to do is a 'find' for those. Cheers -- macropod [MVP - Microsoft Word] "xk" wrote in message ... Hi, When I open a excel file, there is prompt indicating there are link in this file. Since this file has so much sheet and data, is there anyway that I can use it in Macro to find this linked cell ? Thanks xk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do you find and replace tab characters in a cell in Excel? | Excel Discussion (Misc queries) | |||
Excel formula to find position of the contents of a cell within a column. | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |