Canceling Links

[Marc Harmon]

On opening a workbook I use everyday, I get a dialog box:
"The Workbook you opened contains automatic links to information in another
workbook". I always cancel or say no.
How do I find which cell or cells have the links?
Thus I can determine if I need the data or text copy it & then cancel the
link. And thus get rid of the annoying opening dialog box.
I have gone to Edit:Links but the only thing I seem to be able to change
here is the linked subdocument.

Thank You
Marc

 

[JE McGimpsey]

On opening a workbook I use everyday, I get a dialog box:
"The Workbook you opened contains automatic links to information in another
workbook". I always cancel or say no.
How do I find which cell or cells have the links?
Thus I can determine if I need the data or text copy it & then cancel the
link. And thus get rid of the annoying opening dialog box.
I have gone to Edit:Links but the only thing I seem to be able to change
here is the linked subdocument.

Links can exist in cells, names, references.

You can do a quick Find for "[" to find links in cells.

If you still have links, the best tool is Bill Manville's FindLink
add-in, which you can download from

http://www.bmsltd.ie/MVP/Default.htm

It's written for Windows, so the dialogs look a little scrunched, but it
works.