Deleting links to other workbooks

  • Thread starter Thread starter Ro
  • Start date Start date
R

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!!
 
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
 
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.
 
Back
Top