Breaking links between workbooks in Excel 2000

[Kevryl]

I have been using 2000 for a number of years and I often copy ranges from one
workbook into another. Much later I have found that on occasions Excel has
created a link (without asking) and I am asked every time I open a workbook
if I want to update data from (an)other, unidentified workbook(s). As my
workbooks are all stand-alone, I always answer "no".

As yet I have been unable to find a way to prevent this from happening, or a
way to erase the links. Annoyingly, the tiny edit/Links dialogue box gives no
information as to which cells are linked and the buttons are either greyed
out or do nothing. There is no button for delinking or erasing.

(I wonder if Excel 2007 handles this better?)

Cheers

 

[Kevryl]

Thanks Mike, but unfortunately in Excel 2000 there is no option under
Edit/links to break a link. There are 3 buttons: "Update Now", (greyed out)
"Open Source" (black, but can't find the file, understandably as I work
between computers and drives), and "Change Source" (greyed out). There are
2 radio buttons, "Automatic" and "Manual" (greyed out).

The information window shows there are 3 links, and has 4 fields; "Source
file" (full path and name not visible as window is too tiny and
non-expandable) "Item", "Type" and "Status".

Thats it. nothing more, and I can't find anything in the "Help" files
concerning "breaking", "erasing" or "removing" a link.