Question about link

E

Excel heavy user

I have a file shows "The workbook you opened contains automatic links to
information in antoher workbook" every time I open it. Is there a easy way to
check out which cell is link to other file?

Thanks.

Jason
 
K

Kevin H. Stecyk

Excel heavy user...
I have a file shows "The workbook you opened contains automatic links to
information in antoher workbook" every time I open it. Is there a easy way
to
check out which cell is link to other file?

Thanks.

Jason
Click to expand...


From Gord in another post....

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

Hope that helps.

Kevin
 
T

Treesy

You should be able go to Edit | Links to view what file(s) the workbook is
linking to. Then you can do a "Find" for that filename or part of the
filename to locate the cell that is linking to that file.

Good luck!
 
J

Jason

Thanks.

Jason

Treesy said:
You should be able go to Edit | Links to view what file(s) the workbook is
linking to. Then you can do a "Find" for that filename or part of the
filename to locate the cell that is linking to that file.

Good luck!
Click to expand...
 
Top