I have a number of cells within an Excel file that are linked to cells
in other Excel files. Is there a way to identify which cells in a file
are linked to other files?


--
JJC
------------------------------------------------------------------------
JJC's Profile: http://www.excelforum.com/member.php...o&userid=20027
View this thread: http://www.excelforum.com/showthread...hreadid=346119

Here's the brute force method:

If you go to Edit/Links you will see the list of external
files. You can do a find for these filenames in your
worksheets.

If you do a find all, then hit "ctrl + A" to select all,
then escape, all the cells with links to that workbook
will be highlighted. You can then color code these cells.

Of course you have to do the same for your other
worksheets, and start over for the next file if you have
links to more than one file. At least you can use a
different color code for each file.


-----Original Message-----

I have a number of cells within an Excel file that are
linked to cells
in other Excel files. Is there a way to identify which
cells in a file
are linked to other files?


--
JJC
----------------------------------------------------------
--------------
JJC's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=20027
View this thread:
http://www.excelforum.com/showthread...hreadid=346119

.

JJC

Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.

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

With this add-in you can find and delete links if any exist.


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 15:21:44 -0600, JJC
wrote:


I have a number of cells within an Excel file that are linked to cells
in other Excel files. Is there a way to identify which cells in a file
are linked to other files?