Deleting links to other workbooks

[Ro]

I copied some cells from other workbooks and there are
now links that I need to delete. I have clicked
on "Edit" "Links" and there are two links listed. How
can I delete them.

Please Help!!

 

[Bill Lunney]

Do a search throughout your worksheets for the filename of the workbook you
were linking to. You can search all worksheets at once by using shift to
highlight the desired sheets then using find.

Once you find the link just delete it and go back to Edit > Links and see if
any more exist. Remember named ranges etc. could also be setup as a link.



--
Regards,


Bill Lunney
www.billlunney.com

 

[Dave Peterson]

If you try the other suggestions and still have links lurking that you can't
find, you may want to use Bill Manville's addin:

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

Even if you don't actually need it for your current project, get a copy. It's
one of those must-have utilities.