Hassan, you can use the Find function on the menu to produce a list of
hyperlink addresses to cells containing external links.
All external links start with an = sign followed by the name of the workbook
in brackets, so you can do a find and look for "=[".
Press <Ctrl> + F, or click EDIT on the menu and select FIND. In the FIND
WHAT field enter "=[" w/o the quotes and then click the FIND ALL command
button.
This produces a list of cells containing the =[, and I can't imagine those 2
sequential characters used in anything other than a formula function.
A sub window opens up in the FIND AND REPLACE dialog box with the following
columns:
Book | Sheet | Name | Cell | Value | Formula
The workbook, the sheet name, the named range (if any) , the cell the link
was found, the current cell value and it's formula are displayed on right
after the other. Clicking any of the matches in the list will move the cell
pointer to the matching cell in the worksheet.
Hope this helps.
