canceling links between workbooks

eliW · Mar 6th, 2002, 05:49 AM

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 · Mar 6th, 2002, 05:52 AM

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 · Mar 6th, 2002, 06:25 AM

Quote:

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 · Mar 6th, 2002, 01:19 PM

Eli,

see if this helps

http://www.mrexcel.com/board/viewtop...pic=57&forum=2

Barrie Davidson · Mar 6th, 2002, 02:12 PM

Answered at

http://www.mrexcel.com/board/viewtop...c=1419&forum=2

Regards,

Chris Davison · Mar 6th, 2002, 02:58 PM

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

no offence mate

Barrie Davidson · Mar 6th, 2002, 03:01 PM

Quote:

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

no offence mate
[img]/board/images/smiles/icon_smile.gif[/img]

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

Chris Davison · Mar 6th, 2002, 03:05 PM

kickass

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

Mar 6th, 2002, 05:52 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	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. __________________ ~Anne Troy

Mar 6th, 2002, 01:19 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Eli, see if this helps http://www.mrexcel.com/board/viewtop...pic=57&forum=2 __________________ :: Pharma Z - Family drugstore ::

Mar 6th, 2002, 02:12 PM	#5
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Answered at http://www.mrexcel.com/board/viewtop...c=1419&forum=2 Regards, __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 05:49 AM	#1
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	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

Mar 6th, 2002, 02:58 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	sorry Barrie, I think I must have missed that original reply no offence mate

Mar 6th, 2002, 03:05 PM	#8
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	kickass excellent site by the way Barrie, those last 50 hits have been me