canceling links between workbooks

[eliW]

I am keeping to get a message whenever I open one of my workbooks telling me that this workbook has automatic link to other workbook etc.
This happend after I copied some material from this workbook to another. But really I did not intended to link between them.
How can I find and cancel the link if it exsists at all?
Eli

 

[Anne Troy]

Hit Edit-Links to see if it's linking to external files.

Hit Insert-Name-Define and see if any named ranges are pointing to external references.

 

[eliW]

On 2002-03-06 04:52, Dreamboat wrote:
Hit Edit-Links to see if it's linking to external files.

Hit Insert-Name-Define and see if any named ranges are pointing to external references.

Thank you Dreamboat
Yes it's really links to an external file which no longer exsists
How can I get rid of the link?
Eli

 

[Chris Davison]

Eli,

see if this helps

http://www.mrexcel.com/board/viewtopic.php?topic=57&forum=2

 

[Barrie Davidson]

Answered at

http://www.mrexcel.com/board/viewtopic.php?topic=1419&forum=2

Regards,

 

[Chris Davison]

sorry Barrie, I think I must have missed that original reply

no offence mate

 

[Barrie Davidson]

On 2002-03-06 13:58, Chris Davison wrote:
sorry Barrie, I think I must have missed that original reply

no offence mate
/board/images/smiles/icon_smile.gif

Absolutely none taken (no big ego here - no room for egos with this many smart people on the board).

 

[Chris Davison]

kickass

excellent site by the way Barrie, those last 50 hits have been me