Automatic Link to another workbook

[Barry]

I have a workbook created that, every time I open it, I
get the question: Do you want to update the automatic link
to data in another workbook?

I didn't consciously set up a link and I don't want to get
this message. How do I find this link and break it so I
will not continue to get this message?

Any help is appreciated.

 

[Davi]

Close any other Excel workbooks you have open and do a "Find" for :\ (colon
backslash).

If you have several worksheets in your workbook, ask Excel to search the
entire workbook by selecting find within "Workbook" instead of "Sheet" (this
is under Options in your Find window).

Remove the formula by deleting it, or if you want to keep the data but
remove the link, Copy, Paste Special, Value.

 

[Dave Peterson]

But they can be difficult to find. I'd use Bill Manville's addin to help find
the pesky ones.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp