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