Breaking the link
 

Jayceejay, Did you ever get your link broken? I have the same problem. And
I don't see where there was ever a clear answer to what to do. I do not want
my "current" sheet linked to anything.
I am with you.... HELP!!

T

"jayceejay" wrote:

HELP.....

I am working with Excel 2000.

I have a workbook that contains a sheet that references cells in another
workbook (ie: A link exists pulling the data from a source workbook to a
destination workbook.) That SOURCE workbook has been deleted. HOW do I get
the data in the destination file to "UNLINK" from the non-existent source?
When I go to EDIT and LINK, I do not see a way to BREAK the link. I can do
everything else BUT break the link. I just want the pesky boxes to stop
popping up every time I open the file. Manually re-entering the data would
be a real pain, because there is a lot of it. I know the solution is easy in
XP, but I don't see the same "Break the Link" options in Excel 2000.

Jay

Did you try that findlink addin that you quoted in your other post?

Bill Manville's FindLink addin:
http://www.oaltd.co.uk/MVP/Default.htm



T wrote:

Jayceejay, Did you ever get your link broken? I have the same problem. And
I don't see where there was ever a clear answer to what to do. I do not want
my "current" sheet linked to anything.
I am with you.... HELP!!

T

"jayceejay" wrote:

HELP.....

I am working with Excel 2000.

I have a workbook that contains a sheet that references cells in another
workbook (ie: A link exists pulling the data from a source workbook to a
destination workbook.) That SOURCE workbook has been deleted. HOW do I get
the data in the destination file to "UNLINK" from the non-existent source?
When I go to EDIT and LINK, I do not see a way to BREAK the link. I can do
everything else BUT break the link. I just want the pesky boxes to stop
popping up every time I open the file. Manually re-entering the data would
be a real pain, because there is a lot of it. I know the solution is easy in
XP, but I don't see the same "Break the Link" options in Excel 2000.

Jay


--

Dave Peterson