External links

[Sena]

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

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP

 

[whydoyoumakethingsoverlycomplicated]

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.

 

[Dave Peterson]

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.

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.

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

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

 

[Gord Dibben]

And if the links are in defined names?

What then?


Gord

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.

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

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