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

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=37931

bill manville's findlink addin.

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


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


funkymonkUK wrote :


Hi

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

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

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=37931

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

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=37931

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.



"funkymonkUK" wrote:


Hi

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


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=379312