How do I find and break links?

Mar 14th, 2002, 03:51 PM

I have a large spreadsheet. When I go to Edit/Links, it says I have links to two other spreadsheets on my C drive. I've done a Find for the filenames and they don't turn up in any of the tabs. Nothing ending in XLS.

Is there a way to find which formulas contain the links? Could something besides formulas be linked? I want to get rid of the links.

lenze · Mar 14th, 2002, 03:54 PM

Check to see if you have any Named Ranges linked to other Workbooks

Jack in the UK · Mar 14th, 2002, 04:08 PM

Hi --

Common question.. can i suggest search links and these bundels there. Check out my pal Chris Davidson, he love links and has a way arrond this, find him in memebers.. about assigning links to dummy link delete... very cleaver.

NateO · Mar 14th, 2002, 04:34 PM

A quick way to look at your formulae is by hitting your ctrl key and ~ at the same time. Links also tend to build up in the name ranges. Go to insert->names->define... and if you have names, just highlight them and see what they're referring to.

Also, these guys say they have a program to delete the links, haven't tried it, but here's the link:

http://www.erlandsendata.no/english/.../findlinks.htm

Hope this helps.

Cheers, NateO

[ This Message was edited by: NateO on 2002-03-14 15:39 ]

RaoulF · Mar 20th, 2002, 09:58 AM

NateO

I was trying to get rid of some similarly ghostly links, so I followed your "Ctrl+~" advice in one of the sheets of my workbook. It didn't appear to do anything at all, but somehow the links problem has stopped popping up! How did this fix my problem??

Thanks BTW!!

Mar 14th, 2002, 04:08 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- Common question.. can i suggest search links and these bundels there. Check out my pal Chris Davidson, he love links and has a way arrond this, find him in memebers.. about assigning links to dummy link delete... very cleaver. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Mar 14th, 2002, 03:51 PM	#1
Guest Posts: n/a	I have a large spreadsheet. When I go to Edit/Links, it says I have links to two other spreadsheets on my C drive. I've done a Find for the filenames and they don't turn up in any of the tabs. Nothing ending in XLS. Is there a way to find which formulas contain the links? Could something besides formulas be linked? I want to get rid of the links.

Mar 14th, 2002, 03:54 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Check to see if you have any Named Ranges linked to other Workbooks

Mar 14th, 2002, 04:34 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	A quick way to look at your formulae is by hitting your ctrl key and ~ at the same time. Links also tend to build up in the name ranges. Go to insert->names->define... and if you have names, just highlight them and see what they're referring to. Also, these guys say they have a program to delete the links, haven't tried it, but here's the link: http://www.erlandsendata.no/english/.../findlinks.htm Hope this helps. Cheers, NateO [ This Message was edited by: NateO on 2002-03-14 15:39 ]

Mar 20th, 2002, 09:58 AM	#5
RaoulF New Member Join Date: Mar 2002 Location: London, UK Posts: 17	NateO I was trying to get rid of some similarly ghostly links, so I followed your "Ctrl+~" advice in one of the sheets of my workbook. It didn't appear to do anything at all, but somehow the links problem has stopped popping up! How did this fix my problem?? Thanks BTW!!