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

.