Excell - LInk - How do you stop them?

[microcare]

I re use sheets but after a time there is a build up of links to old files. I can see them through VIEW&gt;LINKS but how do I delete/unlink them ?<br>

 

[BobCrawf]

Go to Microsoft Office site and get Clean.xla.<br><br>Clean.xla will remove all links in your workbook.<br><br>Otherwise go to Insert/Names/Define, look through the list for all range names refering to other workbooks and delete them. <br><br>In the future try to keep a 'clean' copy of your workbook with no links as a template to re-use.<br><br>Bob Crawford

 

[microcare]

Thanks<br>I'll go after clean.xla<br>I've tried Insert&gt;Names&gt;define but even with that correct, I still have links<br>Again many thanks<br>