Breaking the link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Jayceejay,
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.
Click to expand...

In edit links, select change source and point to the workbook that contains
the link(s).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Thanks Jan, but I'meven more confused now...How do I point to a source that
no longer exists? And if I could point to it, what would I do...click on
it?? What do I change the source to?
 
jayceejay said:
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
Click to expand...

Go here; http://www.bmsltd.ie/MVP/MVPPage.asp and download and install the
Findlink addin.
 
Hi Jayceejay,
What do I change the source to?
Click to expand...

The workbook itself: the workbook's file that you are working in.
So if you've opened

c:\data\YourBook.xls

which contains links to

c:\data\YourOtherBook.xls

choose edit, links and point to

c:\data\YourBook.xls

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
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
 
Back
Top