Linked Documents

[elmorocks]

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]

have you tried under the edit menu
links
break source?

 

[Ricky Morris]

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]

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