Help!

How to find the linked cell in EXcel

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links RSS
Next:  Publish or Save to PDF in Excel 2007  
Author Message
xk
External


Since: Nov 17, 2006
Posts: 3



PostPosted: Fri Nov 17, 2006 6:48 pm    Post subject: How to find the linked cell in EXcel
Archived from groups: microsoft>public>excel>links (more info?)

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
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Sat Nov 18, 2006 8:47 pm    Post subject: Re: How to find the linked cell in EXcel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
xk
External


Since: Nov 17, 2006
Posts: 3



PostPosted: Mon Nov 20, 2006 12:50 pm    Post subject: Re: How to find the linked cell in EXcel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>
>
>
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Tue Nov 21, 2006 7:54 pm    Post subject: Re: How to find the linked cell in EXcel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Wed Nov 29, 2006 3:34 pm    Post subject: Re: How to find the linked cell in EXcel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
> >
> >
> >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum