External links
 

Hi,
I inherited some files from my predecessor, in which there are so many
external links to so many other files. I need to know which cells are linked.
I tried checking on 'Edit -- Links' it only shows the source but not the
destination cells.

Any help to find the destination cells pls? - Thanks

--
Cheers !

External links
 

Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 07:52:00 -0700, Sena
wrote:

Hi,
I inherited some files from my predecessor, in which there are so many
external links to so many other files. I need to know which cells are linked.
I tried checking on 'Edit -- Links' it only shows the source but not the
destination cells.

Any help to find the destination cells pls? - Thanks

External links
 

This is a ridiculous solution. Simply open the Find search box and search for
square brackets [ or ]. Every link has one in it, this is the easiest and
quickest way to find a link in an Excel file.

"Gord Dibben" wrote:

Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm

External links
 

Then you haven't used links very often.

Links can be difficult to find and they can hide in places where Edit|Find can't
look.

whydoyoumakethingsoverlycomplicated wrote:

This is a ridiculous solution. Simply open the Find search box and search for
square brackets [ or ]. Every link has one in it, this is the easiest and
quickest way to find a link in an Excel file.

"Gord Dibben" wrote:

Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm



--

Dave Peterson

External links
 

And if the links are in defined names?

What then?


Gord

On Wed, 27 Jan 2010 04:07:02 -0800, whydoyoumakethingsoverlycomplicated
icrosoft.com wrote:

This is a ridiculous solution. Simply open the Find search box and search for
square brackets [ or ]. Every link has one in it, this is the easiest and
quickest way to find a link in an Excel file.

"Gord Dibben" wrote:

Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm