Finding links

[funkymonkUK]

Hi

I have a workbook which looks at other workbooks. how do i find th
cells that are linking to other workbooks and then break that link b
deleting that formula etc

 

[keepITcool]

bill manville's findlink addin.

from http://www.bmsltd.ie/MVP/Default.htm


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


funkymonkUK wrote :

 

[anilsolipuram]

Select all, edit find and search for ".xls", you should see all th
cells which have link to other workbook

 

[funkymonkUK]

i tried that and it does not seem to work is there a setting i need i
to be on to work

 

[anilsolipuram]

can you paste the formula of one of the cell that has link to th
other workboo

 

[funkymonkUK]

see the thing is I am using this workbook and every time i open it sa
it is linked what i dont know if how to get rid of the links as thi
workbook does not need to be linked any ideas? I dont know which cel
has got the formula in else i would just delete it

 

[anilsolipuram]

Two ways:

1) if you are sure you are not using any formulaes, select al
cells,right click->copy, select cell A1,right click-> paste special-
select values and click ok, repeat this for all the worksheets in th
workbook.

2)select all cells, go to edit->go to->click special button and selec
formulae options, this would hightlight all the cells that hav
formalae, check to see if highlighted cell have link to other workbook
, repeat this for all the worksheets in the workbook

 

[Guest]

Use the utility pointed to by KeepItCool. I use that utility myself and it
works great. There is a good chance that your link is in a named range which
is very difficult to find. You can not just search for it the using typical
find functions.

 

[Guest]

there is a concurrent thread in WorkSheet Functions.

I finally got through to Bill's webpage. His add-in appears very flexible
and will probably do anything you need to w/links.