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

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


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

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!

"Excel heavy user" wrote:

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

Thanks.

Jason

"Treesy" wrote:

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!

"Excel heavy user" wrote:

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