Automatic Link to another workbook

  • Thread starter Thread starter Barry
  • Start date Start date
B

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