find links to another workbook
 

I have a huge workbook that somehow has a link to another workbook. I tried
to search for the [ and found some of the links and removed them, but when I
open the workbook it still states that there are links. How else can I fnd
them. The workbook contains 30 sheets so looking in the cells will not help.

Thanks

There are several other options;

1) You may not know bu you can search multiple sheet by holding down CTRL or
SHIFT then fist to last sheet, then doing a find on .xls

2) Use the Find Link add-in available at
http://www.oaltd.co.uk/MVP/Default.htm
Totaly free

3) Get a copy of John Walkenbacs PUP add-in (£30 or $40) this is more
sophisticated.

Hope that helps

Jimbola



"Patricia" wrote:

I have a huge workbook that somehow has a link to another workbook. I tried
to search for the [ and found some of the links and removed them, but when I
open the workbook it still states that there are links. How else can I fnd
them. The workbook contains 30 sheets so looking in the cells will not help.

Thanks