External links

  • Thread starter Thread starter Sena
  • Start date Start date
S

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
 
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.
 
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.

Gord Dibben said:
Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm
Click to expand...
Click to expand...
 
Back
Top