Removing Links

[Paul W Smith]

I am trying to copy several worksheets from a workbooks to a new workbook
and have all links with the old severed.

I have changed all the formulas to values.

I have deleted every workbook and worksheet name.

Still when I look at Edit | Links some link to the original workbook is
present. Has anyone any ideas what this might be, and more importantly how
do I get rid of it?

PWS

 

[Jeff]

HI,

Maybe this old post from Frank Kabel
will help:

try the following add-in to find/delete these links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

Jeff