Finding and deleting external links!!!

**jonn** · 06-15-2007, 04:11 AM

Hi,

i have this very large work sheet that contains external links that i don't want in. i've tried searching for the link referneces but cannot find them.

how can i find them and delete them

i'm using excel 2000

thanks

**sweep** · 06-15-2007, 04:31 AM

Hi John,

If you just want to dispose of the links, go to

Edit > links > break links

this will convert the cells that contain a link to their current value and remove the link.