Remove automatic links?


Posted by EJG on January 08, 2001 5:55 AM

Good Morning Everyone:
I have a problem and I hope that someone out there may be able to help me.
I created a workbook by copying various sheets of information from various
different workbooks to form one. The problem is that now every time that I
open this newly created workbook it say the following:
"The workbook you opened contains automatic links to information in another workbook.
Do you want to update this workbook with changes made to the other workbook?"
and then it gives me a "yes" or "no" option.

My question is can I make this an independent workbook? Is it possible to remove all
links to other workbooks?

Any help given is greatly appreciated, thank you.



Posted by cpod on January 08, 2001 9:02 AM


If you go to the Microsoft site:

http://support.microsoft.com/support/kb/articles/Q188/4/49.ASP?LN=EN-US&SD=gn&FR=0&qry=delete%20links&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

you can download dellink.xla an add-in that will delink your workbook.