Finding/Deleting Old Links

[f1luvr]

Hi there - please be gentle since this is my first post...

I have a worksheet that used to refer to another worksheet (named ranges in other worksheet). I now want to consolidate this into one worksheet but I'm still seeing the old link show up in Edit|Links. I've changed the location of the named ranges to the current worksheet. How do I find where the old link is and change/delete it?

[jetted]

Hi


There is a few free add-in that may help you out.

http://www.acctadv.com/exceldownloads.php

Thanks
Denis

[f1luvr]

Actually I found the answer in the "Excel Tips" drop-down at the top of the page... I did a Control-F for "[" and I found my unwanted link...

Thanks to all!