Linked Documents

elmorocks · Apr 15th, 2002, 05:42 PM

Hi There.

I created a master document on excel, which consists of worksheets that are individually linked to other Excel Files on a folder. When I opened up the main document, I get an overlay if I want to update the links. When I say yes, I get the overlay to look for certain files. However, those files I don't need. Does anyone know how I can get rid of links.

I went to links under the edit heading. but there is no way to delete them

Thanks
Ernest

brettvba · Apr 15th, 2002, 07:20 PM

have you tried under the edit menu
links
break source?

Ricky Morris · Apr 15th, 2002, 08:52 PM

I wrote a neat little utility that will erase links, or change them to values. Email me, if you're interesting send it to you.

Peter99 · Apr 16th, 2002, 04:29 PM

Go to Microsoft.com/downloads and if you search under excel with the keyword set to links you can download a friendly wizard that gives you controlled deletion of links

Apr 15th, 2002, 08:52 PM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	I wrote a neat little utility that will erase links, or change them to values. Email me, if you're interesting send it to you. __________________ It's never too late to learn something new. Ricky

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

Apr 15th, 2002, 05:42 PM	#1
elmorocks New Member Join Date: Apr 2002 Posts: 1	Hi There. I created a master document on excel, which consists of worksheets that are individually linked to other Excel Files on a folder. When I opened up the main document, I get an overlay if I want to update the links. When I say yes, I get the overlay to look for certain files. However, those files I don't need. Does anyone know how I can get rid of links. I went to links under the edit heading. but there is no way to delete them Thanks Ernest

Apr 15th, 2002, 07:20 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	have you tried under the edit menu links break source?

Apr 16th, 2002, 04:29 PM	#4
Peter99 New Member Join Date: Mar 2002 Posts: 7	Go to Microsoft.com/downloads and if you search under excel with the keyword set to links you can download a friendly wizard that gives you controlled deletion of links