Linked cells

J

JJC

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

BobT

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