How to find the linked cell in EXcel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xk - 17 Nov 2006 21:48 GMT

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 to this Message

macropod - 18 Nov 2006 04:47 GMT

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

Signature

macropod
[MVP - Microsoft Word]

> Hi,
>
[quoted text clipped - 6 lines]
>
> xk

Reply to this Message

xk - 20 Nov 2006 15:50 GMT

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

> Hi xk,
>
[quoted text clipped - 18 lines]
> >
> > xk

Reply to this Message

macropod - 21 Nov 2006 03:54 GMT

Hi xk,

Curious.

In that case, try doing a search for any cells containing ':\' in a formula.

Signature

macropod
[MVP - Microsoft Word]

> Hi, macropod,
>
[quoted text clipped - 14 lines]
>
> xk

Reply to this Message

macropod - 28 Nov 2006 23:33 GMT

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

Signature

macropod
[MVP - Microsoft Word]

> Hi, macropod,
>
[quoted text clipped - 37 lines]
> > >
> > > xk

Reply to this Message